Avatar of Rayne
Rayne
Flag for United States of America asked on

Current Region Usage

Hello Again Dave,

This question is in reference to
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_27727416.html

CurrentRegion Usage Dangers:
Since you are not a supporter of current region – when you have a moment – you can look through the worksheet and let me know if there is any risk or problems with using current region here. Data is getting copied from A to B. B worksheet had some data sets after one blank column from the copied destination. This copying from A to B – will that create any issues – I can’t afford to lose the data set sets –dataI,dataII,dataIII,dataIV
So far the current region is working as expected with no deletion of the important data sets that surround the destination where the copying is happening.

let me know if there is any issues with this current set up or possible issues in future.

thank you
copyOnCondition101.xlsm
Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Rayne

8/22/2022 - Mon
dlmille

It was UsedRange I mentioned can be faulty (re: the last row or column can be incorrect, and also includes any formatting - so if you have a font change at row 50000, then that entire area would be included in the UsedRange).

I am not aware of any problems with CurrentRegion, and formatting issues on the sheet do not impact how CurrentRegion works, though formulas that result in "" are evaluated as if they have data in developing the CurrentRegion address.

Dave
ukerandi

You need to modify your programme

for example if add another dataset old data set going to delete, b'cos of that when you are entering new data record ,need to start from next cell and if someone add button 2 times without knowing if its alreday added no need to add again.
ASKER CERTIFIED SOLUTION
dlmille

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rayne

ASKER
Perfect Dave, Thank you
It’s always good to know alternatives that way we are restricted to just one way of doing things.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23