spreadsheet ranges

[Luis939]

I designed my macro so that it works with one workbook and then makes a reference to another workbook to do somework in that, is there a way of not having to declare a range to work on any part of the other workbook. If i declare cellrange and then say
cellrange.offset(4,0) = myvariable

is there then a way to say offset(1,0) from the cell that has myvariable instead of having to reference cellrange again. basically is there somethign that says do whatever with respect to the last cell worked on without it being the activecell, thanks!

 

[SkipVought]

Hi,

Ranges/cells can be referenced in a great variety of ways, and it depends what you are trying to accomplish.

I often use the workbook.worksheet.Cell(rowNum, colNum) technique. Offset works well too.

If you want to set a new reference point you could use the Set statement.

Why not incriment the offset?


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Zathras]

Whichever way you go (.Cells or .Offset) be consistent. .Cells is 1-based and .Offset is 0-based.

Also, be aware that .Cells(r,c) will always be a one-cell range, while .Offset(r,c) will be a range with the same shape as the referenced range.

So, for example, if you Set rng=Range("A1:C3&quot, then rng.Cells(1,1) will be equivalent to the cell "A1" and rng.Offset(1,1) will be equivalent to the range "B24"

 

[Luis939]

Thanks alot, I wasn't aware of that fact.