Forum Home | Log in | Signup | My Page | Rules | FAQ | Boards | Members | Search
« F@H Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Excel Macros

By: BigApplePi in F@H | Recommend this post (0)
Sat, 21 Mar 15 3:07 AM | 288 view(s)
Boardmark this board | Folding at Home 		Msg. 02642 of 02753
(This msg. is a reply to 02641 by Vgolfmaster)
Jump:
Jump to board:
Jump to msg. #

Vgolf,

Thank you enormously. I just programmed it and it works! This will save me a lot of work.

My job is to classify 3500 names of speeches of a friend by keywords. There are a few hundred keywords. I volunteered to help after the webmaster got tired of doing it without using macros. He did half so I have half to go.


BAP


 - - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Re: Excel Macros
By: Vgolfmaster in F@H
Fri, 20 Mar 15 8:45 AM 		Msg. 02641 of 02753

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.


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