Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Foolacious

(497 posts)
1. I would just set a variable to that value.
Tue Apr 13, 2021, 02:09 AM
Apr 2021

Something like this:


Dim nVal As Long
nVal = Range("C41:C41" ).Value
Range("B1:B" & nVal).Select


But if it's important to get it all into one line of code, you can do this, though it looks a bit opaque:


Range("B1:B" & Range("C41:C41" ).Value).Select
Latest Discussions»Culture Forums»Apple Users»is there a way to create ...»Reply #1