Current Region Usage
Hello Again Dave,
This question is in reference to
https://www.experts-exchange.com/questions/27727416/Print-Area-Reset.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,data
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
This question is in reference to
https://www.experts-exchange.com/questions/27727416/Print-Area-Reset.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,data
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
Last Comment
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.
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect Dave, Thank you
It’s always good to know alternatives that way we are restricted to just one way of doing things.
It’s always good to know alternatives that way we are restricted to just one way of doing things.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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