getting values of a range of data

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cond. Format Data Bars of range based on values of another range	alexmo	Excel Worksheet Functions	4	January 16th 09 04:03 AM
Select different data label range (as values)	MikeM	Excel Programming	2	December 21st 07 08:39 PM
is it possible that the data values shown on the data labels be in a duifferent range	tweety127[_18_]	Excel Programming	0	June 7th 06 10:16 PM
Convert Data Range in to individual values	mistryrg	Excel Discussion (Misc queries)	2	June 7th 06 04:48 PM
Condensing a data range with only a few nonzero values???	Travis.Broersma	Excel Programming	1	March 9th 06 08:56 PM

All times are GMT +1. The time now is 08:02 PM.

Menu

About Us