Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referring to cells on a different worksheet | Excel Discussion (Misc queries) | |||
Referring to columns from within a macro | Excel Discussion (Misc queries) | |||
IF Formula referring to 2 cells | Excel Discussion (Misc queries) | |||
Referring to Cells | Excel Discussion (Misc queries) | |||
Sort a list with cells referring to others cells | Excel Discussion (Misc queries) |