Hello All,
I am kinda new to VBA interacting with excel...or just VBA for that matter. I was wondering if there was a was to determine if a ranged varable (lets say ProductXRange) is empty?
Thank you,
Aaron
forgedascendant
Last Activity: Nov 6 '07, 09:48 PM
Joined: Oct 1 '07
Location:
-
Determining if a range varable is empty
-
Finding Blank cells
Can someone tell me how to find and then select a blank cell from a list of data?
Thanks,
Aaron -
Graphing a Multi Range Area
Can someone please tell me how to graph a series of data from various ranges unioned together on a single line graph in a single series?
For instance if I have data in X and Y columns from rows 1 to 100. And I want to graph rows 1 to 5, 50 to 55, 60 to 70, and 85 to 100 as one series leaving out various points in between the selected data. Can someone please help?
When I try it I get a Run-time error '1004': Unable... -
forgedascendant started a topic Run-time error '1004' Unable to set the XValues property of the series classin Visual BasicRun-time error '1004' Unable to set the XValues property of the series class
Good day everyone,
I am new to this site so please forgive me if this post isn't completly correct. For the past 2 weeks I have been beating my head against the wall trying to figure out what is wrong with the macro I created. The problem I am experiancing is that the range I am trying to put together does not seem to be working for some reason. My entire code is as follows:
...Code:Sub Proto1() ' '
No activity results to display