I know I can Select a Range, let's say I have a currentRegion between Range("A3") to Range("E3")
Range("A3").Select then continue with Selection.EntireRow.Select. But the issue I am facing now is that the later code is taking so much time to run while The range I am only interest into is only the row in the CurrentRegion, that is I want a code would select on from Range("A3:E3") basing on my CurrentRegion. I want the code to be dynamic as I am dealing with more than 700 sheets and their respective CurrentRegion will be changing as I loop through the sheets.
Any help is much appreciated, thank you!