| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a call to a differnt sheet
Should be simple, but I'm stuck. Please help.
The below code works fine working from a sheet named FEATURES: Dim n_RowNumber = As String n_RowNumber = 24 n_Named_Symbology_Create = ActiveSheet.Cells(n_RowNumber, "B") I need to call the n_... variable from a sheet named 'NS'. How do I code for the sheet NS vs. ActiveSheet? Thanks, Ron |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making a call to a differnt sheet
n_Named_Symbology_Create = Sheets("NS").Cells(n_RowNumber, "B")
-- HTH... Jim Thomlinson "Ron" wrote: Should be simple, but I'm stuck. Please help. The below code works fine working from a sheet named FEATURES: Dim n_RowNumber = As String n_RowNumber = 24 n_Named_Symbology_Create = ActiveSheet.Cells(n_RowNumber, "B") I need to call the n_... variable from a sheet named 'NS'. How do I code for the sheet NS vs. ActiveSheet? Thanks, Ron |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making a call to a differnt sheet
Thank you! That was the solution. I tried mutltiple variations but just could
not 'hit' it right. Ron "Jim Thomlinson" wrote: n_Named_Symbology_Create = Sheets("NS").Cells(n_RowNumber, "B") -- HTH... Jim Thomlinson "Ron" wrote: Should be simple, but I'm stuck. Please help. The below code works fine working from a sheet named FEATURES: Dim n_RowNumber = As String n_RowNumber = 24 n_Named_Symbology_Create = ActiveSheet.Cells(n_RowNumber, "B") I need to call the n_... variable from a sheet named 'NS'. How do I code for the sheet NS vs. ActiveSheet? Thanks, Ron |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making a call to a differnt sheet
Hi,
How about : Public n_Named_Symbology_Create 'Place in event sheetActivate in the sheet("NS") module : Sheets("NS").Cells(n_RowNumber, "B") = n_Named_Symbology_Create -- Regards, Halim "Ron" wrote: Should be simple, but I'm stuck. Please help. The below code works fine working from a sheet named FEATURES: Dim n_RowNumber = As String n_RowNumber = 24 n_Named_Symbology_Create = ActiveSheet.Cells(n_RowNumber, "B") I need to call the n_... variable from a sheet named 'NS'. How do I code for the sheet NS vs. ActiveSheet? Thanks, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Pivot chart from 3 differnt sets of data / worksheets. | Charts and Charting in Excel | |||
| Too Many differnt Cell Formats in excel sheet | Excel Discussion (Misc queries) | |||
| Too Many differnt Cell Formats in excel sheet | Excel Discussion (Misc queries) | |||
| Copy sheet cells into differnt workbook/sheet, How? | Excel Discussion (Misc queries) | |||
| Making a Call to an external sheet using a variable... | Excel Worksheet Functions | |||
Linear Mode
