View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LyleF LyleF is offline
external usenet poster
 
Posts: 3
Default Range (variable)

I need to copy a range from one sheet into the exact same row in several
other sheets. I also need to make the row a variable so it can be changed
each month and then run the macro with the new row number.
Enddate is the variable and is being picked up correctly. I am getting
error 1004
as I try to pass Enddate into the range. Below is where I am now.

Range("b&Enddate").Select
--
Thanks
Lyle