I am trying to obtain No. of used cells between columns 'L - AP" Column #(12-42) in the below code, but i only ever get a value of 1??
With current data, i should get a 6.
![]()
Please Login or Register to view this content.
I am trying to obtain No. of used cells between columns 'L - AP" Column #(12-42) in the below code, but i only ever get a value of 1??
With current data, i should get a 6.
![]()
Please Login or Register to view this content.
How about this ?
![]()
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks bakerman2, perfect.
I can work with that as is.
You're welcome and thanks for rep+.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks