LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default referring to columns/cells using numbers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referring to cells on a different worksheet GARY Excel Discussion (Misc queries) 3 November 10th 09 12:24 AM
Referring to columns from within a macro Blobbies Excel Discussion (Misc queries) 4 August 9th 09 10:03 PM
IF Formula referring to 2 cells Marilyn Excel Discussion (Misc queries) 1 March 22nd 09 08:45 PM
Referring to Cells PeterM Excel Discussion (Misc queries) 4 May 30th 08 02:37 PM
Sort a list with cells referring to others cells Friis(DK) Excel Discussion (Misc queries) 6 February 24th 07 03:56 AM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"