Rayne
asked on
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 IV
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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