View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buffyslay Buffyslay is offline
external usenet poster
 
Posts: 40
Default VBA cannot see data in Range("G1").select - but its there!!

VBA cannot see data in Range("G1").select - but its there!!

i have tried

strDate = Range("G1").Text
strDate = Range("G1").value
strDate = Range("G1").Cells.Value


why isnt this picking up the data from the cell?

http:\\www.buffyslay.co.uk