View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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