PDA

View Full Version : Newbie question



reemoe
08-22-2007, 12:55 PM
I inherited a worksheet with macros, of which I am only vaguely familiar.

In the VBA code, a line reading:

Range ("D2").Select

is found. How is this range given the name D2, and how do I go about seeing what is contained in this range?

Thanks in advance!

Bob Phillips
08-22-2007, 01:07 PM
It isn't given the name D2, it is referring to the cell D2 on the activesheet. Just look at it in Excel.

paulked
08-22-2007, 01:08 PM
That is just selecting the Cell D2 on the sheet :wink:

Regards

Paul Ked

reemoe
08-22-2007, 01:39 PM
Thanks. Now how big is a "SmallScroll"?

As in:

ActiveWindow.SmallScroll Down:=60

And how does a positive number differ from a negative (like Down:=-9)?

Thanks again!

Bob Phillips
08-22-2007, 01:58 PM
It is usually a result of the macro recorder when you move when recording, and is usually totally redundant. Ditch it and see.

reemoe
08-22-2007, 02:26 PM
Thanks again. One more: What does the following mean:

Application.CutCopyMode = false

Bob Phillips
08-22-2007, 02:28 PM
What is this, homework?

reemoe
08-23-2007, 09:21 AM
Not homework; just trying to modify a document at work created by someone else.

Could you please answer this hopefully final question in my last post?

mdmackillop
08-23-2007, 09:37 AM
Select a group of cells and press Ctrl+C.
"Application.CutCopyMode = false" Removes the blinking line.

Bob Phillips
08-23-2007, 10:10 AM
So why don't you post all the code and ask application questions?