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!!
strDate is a string, and there is a string in the cell 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? it worked, and then it stopped - i dont know why it started again and now its stopped again - the only change recently is we had service pack updates here at work, which is why i had to re-write it SP KB824141 / KB832483 / KB823718 http:\\www.buffyslay.co.uk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA cannot see data in Range("G1").select - but its there!!
try with the sheetname like
strDate = Worksheets("SheetName").Range("G1") manges -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
VBA cannot see data in Range("G1").select - but its there!! | Excel Programming | |||
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 |