« F@H Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Excel Macros

By: Vgolfmaster in F@H | Recommend this post (0)
Fri, 20 Mar 15 8:45 AM | 323 view(s)
Boardmark this board | Folding at Home
Msg. 02641 of 02753
(This msg. is a reply to 02639 by BigApplePi)

Jump:
Jump to board:
Jump to msg. #

BAP,

you are looking for the offset function, Google that and it should lead you down the right road.

ex:

ActiveCell.Offset(1, 2).Select

first number is how many cells to move down, 2nd number is how many to move to the right. Negative integers for up or left.


"Friends don't let friends dial-up"


- - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Re: Excel Macros
By: BigApplePi
in F@H
Wed, 18 Mar 15 8:39 PM
Msg. 02639 of 02753

NewSunR. Gas bubble? What keeps the gas from escaping? Is it encapsulated or does the back of the eye just hold it?

Excel. Row duplication code worked when I removed code specific to a particular cell.

Moving the cursor over is the problem. I can't read the code because I don't understand it enough to modify it to move the cursor to the right.

Here is what happens when I put the cursor on row 1820. I record with moving the cursor to column D. The code says, Range("D1820").Select. That is good. But when I try out row 1824, it moves the cursor back to D1820. I want it to go to D1824. Changing the code to D$1820 doesn't work.


« F@H Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next