Thread: getting values of a range of data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_1220_] Simon Lloyd[_1220_] is offline
external usenet poster
  
Posts: 1
Default getting values of a range of data

Ryu, what is the entire range you are trying to encompass?ryu;441175 Wrote:
I am trying to store the values of all the data in the worksheet but I
keep getting the Run-time error '1004'. Please help.

Here is my code

Dim RangeValues As Variant

RangeValues =
srcWorkBook.Worksheets(sheetName).Range("A2",Range ("A2").End(xlDown).End(xlToRight)).Value

Thank you so much!


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122376

Reply With QuoteReply With Quote