How do I use range with lastrow in this case?
(this is what I tried, but it didn't work)![]()
Range(("B" & lrTest - 1):("D" & lrTest - 1)).Select
If lastrow were 26, for example, it should be Range("B25":"D25")
How do I use range with lastrow in this case?
(this is what I tried, but it didn't work)![]()
Range(("B" & lrTest - 1):("D" & lrTest - 1)).Select
If lastrow were 26, for example, it should be Range("B25":"D25")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks