Loop QUESTION to end of data range...
HI:
Can you tell me how to loop to the end of the data range without this being static? Please numrows = Range("A2", Range("A2").End(xlDown)).Rows.Count Range("A2").EntireColumn.Select For x = 1 To 3000 Thanks so much Just need to go to the end value which will change everytime the report is ran by user |
All times are GMT +1. The time now is 11:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com