View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stan Plumber Stan Plumber is offline
external usenet poster
 
Posts: 5
Default 1004 App - defined or object-defined error

When I run a procedure with this line of code I get the 1004 app
define... error. Yet when I place the cursor over the variables it
references the right worksheet, column, and row. and even the value.
What's wrong with this line of code if:

Debug.Print Worksheets(glr_CopyWKS).Range(Cells(lngHeader,
lngX)).Value

glr_copywks = the activeworksheet
lngheader = a row in the activeworksheet
and lngx = a column in the activeworksheet

TIA

Stan