PDA

View Full Version : Variable names to refer to column and row



kualjo
04-22-2008, 12:55 PM
I have two variables called "ro" and "col". Each is found by searching for two dates on a spreadsheet -- one across the top and the other down the left -- then returning the column and row references. Now I want to go to cell [col][ro]. I know this can't be as hard as I'm making it, but I can't do it without constantly getting a run-time error. How do I fill in the blank using my variable names?

range( ? ).Select

kualjo
04-22-2008, 01:03 PM
Got it. I changed "range" to "cells" and voila! I knew it was simple!

lucas
04-22-2008, 02:41 PM
Thanks for posting your solution. You can mark your own thread solved by using thread tools at the top of the page.