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