LinkBack URL
About LinkBacks
I need to select a range of cells based on a column number.
Thank you
myrow = 10 mycol = myrow - 5 ' How do I convert mycol to a letter so I can myrange = mycol & myrow Range(myrange).Select
I need to select a range of cells based on a column number.
Thank youmyrow = 10 mycol = myrow - 5 ' How do I convert mycol to a letter so I can myrange = mycol & myrow Range(myrange).Select
Last edited by iturnrocks; 11-21-2007 at 09:51 AM.
-Dan
www.ksvp.org
1)
2)myrow = 10 mycol = myrow - 5 Cells(myrow, myrow-5).Select
You don't need to "Select" the range most of the time, anyway.myrow = 10 mycol = Replace(Cells(1,myrow - 5).Address(0,0),"1","") Range(mycol & myrow).Select
Originally Posted by iturnrocks
Cells(myrow, mycol).Resize(51).Select
iturnrocks
Please read forum rules & wrap your VBA code
A thread with the rules is available at the top of each forum or see links below
If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
If that "code" was actual code I would have wrapped it. That was only me trying to explain what I wanted to do. But I will go back and wrap it anyway.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks