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

  • Thread starter Thread starter Buffyslay
  • Start date Start date
B

Buffyslay

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
 
try with the sheetname like
strDate = Worksheets("SheetName").Range("G1")

manges
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA cannot see data in Range("G1").select - but its there!! 2
Offset (start after last row of previous procedure)-Merging macros 3
Email a selected range using sendmail 2
Put a picture in a text box without selecting it? 2
Concatenate many cells without zero's 9
Volatility, recalculation 7
Re: VBA to zip excel spreadsheet using xp's compression system 1
Run-Time error '9' Subscript out of Range 7

Back
Top