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

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