Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range, conditional formatting
This is probably something very simply solved but it has eluded me. How
does one perform an offset using the values in named cells. Example: cell A1 named LeftRight cell A2 named UpDown cell C3 named Base The names were defined via the spreadsheet. Range("base").select Activecell.Offset(UpDown,LeftRight).Select In general what I am trying to do is move the cursor(activecell) based on user input in the named cells offset from the starting position "base". The immediate window is telling me that LeftRight and UpDown are zero, ie. undefined (when using Option Explicit). There are values in those cells. Thanks in advance Drabbacs |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range, conditional formatting
You have to range them as well
Range("base").select Activecell.Offset(Range("UpDown").value,Range("Lef tRight").value).Select -- HTH RP (remove nothere from the email address if mailing direct) "drabbacs" wrote in message oups.com... This is probably something very simply solved but it has eluded me. How does one perform an offset using the values in named cells. Example: cell A1 named LeftRight cell A2 named UpDown cell C3 named Base The names were defined via the spreadsheet. Range("base").select Activecell.Offset(UpDown,LeftRight).Select In general what I am trying to do is move the cursor(activecell) based on user input in the named cells offset from the starting position "base". The immediate window is telling me that LeftRight and UpDown are zero, ie. undefined (when using Option Explicit). There are values in those cells. Thanks in advance Drabbacs |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range, conditional formatting
That did it, thanks.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range, conditional formatting
Use this if base is one cell
Range("base").Offset(Range("UpDown").Value, Range("LeftRight").Value).Select -- Regards Ron de Bruin http://www.rondebruin.nl "drabbacs" wrote in message oups.com... This is probably something very simply solved but it has eluded me. How does one perform an offset using the values in named cells. Example: cell A1 named LeftRight cell A2 named UpDown cell C3 named Base The names were defined via the spreadsheet. Range("base").select Activecell.Offset(UpDown,LeftRight).Select In general what I am trying to do is move the cursor(activecell) based on user input in the named cells offset from the starting position "base". The immediate window is telling me that LeftRight and UpDown are zero, ie. undefined (when using Option Explicit). There are values in those cells. Thanks in advance Drabbacs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on active Named Range; IF Function to VBA | Excel Worksheet Functions | |||
Conditional formatting when text is contained in a named range | Excel Discussion (Misc queries) | |||
Conditional formatting 'Named Range' dilemma | Excel Worksheet Functions | |||
Conditional Formatting - 2 Worksheets one Named Range | Excel Worksheet Functions | |||
Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions |