When I capture a cells location, I seem to only have the decimal
notation.
eg: (cycling through using a For each Col in range.columns
Worksheets("Data").Range("ColStart").Value = col.Column
So I store the column number (eg: 4), but I have a bit more difficulty
dealing with this #, rather than the letter notation (ie: F3). I use
this column later to define a range, but am having trouble:
eg:
rng = Worksheets(sSheetName).Range(3, 4)
This (3, 4) refers to row 3, column 4 - which I could use, but the syntax
for declaring the range seems more difficult. I have tried: (Range(3,
4:3, 232) but it doesn't like the colon.
Does anyone know how to define a range?
I know this should be a RTFM post - but I can't seem to search only the
VB part of the manual. I have a couple of Excel books, which have gotten
me to Range(3, 4), but not past that.
Thanks,
M.I.