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 |
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 |
named range, conditional formatting
That did it, thanks.
|
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 |
All times are GMT +1. The time now is 08:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com