Code macro how to select used rows of a column
Closed
Kevin
-
Dec 16, 2015 at 11:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Dec 21, 2015 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Dec 21, 2015 at 11:02 AM
Related:
- Code macro how to select used rows of a column
- Vba select case like - Guide
- Cs 1.6 code - Guide
- How to select at the rate in laptop - Guide
- How to delete a column in word - Guide
- Samsung volume increase code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Dec 21, 2015 at 11:02 AM
Dec 21, 2015 at 11:02 AM
Hi Kevin,
Instead of using:
Range("I20000").Activate
Try this:
Range("I2:I"&cells(rows.count,"I").end(xlup).row).activate
Best regards,
Trowa
Instead of using:
Range("I20000").Activate
Try this:
Range("I2:I"&cells(rows.count,"I").end(xlup).row).activate
Best regards,
Trowa
