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

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

Hi
what value is in G1 and how is strDate defined

--
Regards
Frank Kabel
Frankfurt, Germany


Buffyslay wrote:
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

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

strdate is a string - the info in "G1" is string, and oddly it was
picking it up before, but now has stopped.....?



_________________________________________

Willow: "I knew it! I knew it! Well, not in the sense of having the
slightest idea, but I knew there was something I didn't know."

http://www.buffyslay.co.uk

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!