Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The Range method returns a relative reference. If unqualified it
defaults to the active sheet and references are relative to the top-left cell - i.e. relative to cell A1 and Range("C3") refers to cell C3. However, if you select cells F5:G6 and specify Selection.Range("C3") it will return cell H7. In other words, "C3" specifies an offset from the top-left corner of the selection (F5) instead of from the top-left corner of the worksheet. Aha, got it. Thanks to all for the answers. Most helpfull. -- Vänligen Konrad --------------------------------------------------- Sleep - thing used by ineffective people as a substitute for coffee Ambition - a poor excuse for not having enough sence to be lazy --------------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
Target area in Excel chart with different color | Charts and Charting in Excel | |||
Target As Excel.Range or Target As Range | Excel Programming | |||
Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range) | Excel Programming | |||
"find" and "filter" working weirdly | Excel Discussion (Misc queries) |