View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Set range based on cell contents - help required

Range("N196") and Range("N197") are on the new sheet you just added where
you have added no values? Or is the code in the sheet module of the sheet
with the Dates?

--
Regards,
Tom Ogilvy

"N E Body " wrote in message
...
Many thanks

That did the trick

Kenny


---
Message posted from http://www.ExcelForum.com/