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

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!


--
ryu
------------------------------------------------------------------------
ryu's Profile: http://www.thecodecage.com/forumz/member.php?userid=602
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122376

Reply With QuoteReply With Quote