Difficult in creating a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having difficulty in creating a section of a macro. I need to be able to copy and paste a range of cells from one area to another. The copied area of cells needs to be such that when I push CTRL-ArrowUp from below it, that it goes to the first actual number instead of the first copied cell. I have tried <Copy> and then <Paste Special> and checked only the values box, but this still results in the cursor moving only to the bottom-most copied cell instead of the bottom-most cell with an actual number in it.

I need to do this so that I can make charts that accurately reflect the amount of data i have, instead of having false zeros (i.e. it drops to zero on the graph)
 
Zysik,

I didn't quite follow all that. But did you try this? Select your chart.
Tools, Options, Chart tab. Select "Not plotted -- leave gaps."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Zysik said:
I am having difficulty in creating a section of a macro. I need to be
Click to expand...
able to copy and paste a range of cells from one area to another. The
copied area of cells needs to be such that when I push CTRL-ArrowUp from
below it, that it goes to the first actual number instead of the first
copied cell. I have tried <Copy> and then <Paste Special> and checked only
the values box, but this still results in the cursor moving only to the
bottom-most copied cell instead of the bottom-most cell with an actual
number in it.
I need to do this so that I can make charts that accurately reflect the
Click to expand...
amount of data i have, instead of having false zeros (i.e. it drops to zero
on the graph)
 
Back
Top