Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Error 1004, "select method of range class failed" | Excel Programming |