Newbie question

[reemoe]

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]

It isn't given the name D2, it is referring to the cell D2 on the activesheet. Just look at it in Excel.

[paulked]

That is just selecting the Cell D2 on the sheet :wink:

Regards

Paul Ked

[reemoe]

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]

It is usually a result of the macro recorder when you move when recording, and is usually totally redundant. Ditch it and see.

[reemoe]

Thanks again. One more: What does the following mean:

Application.CutCopyMode = false

[Bob Phillips]

What is this, homework?

[reemoe]

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]

Select a group of cells and press Ctrl+C.
"Application.CutCopyMode = false" Removes the blinking line.

[Bob Phillips]

So why don't you post all the code and ask application questions?