#1
|
|||
|
|||
A simple select for a given math formula
Here goes: I want to write a macro which will start at a specific cell and range like this A5356:B5360 , select this range then go 55 cells down and select the next 4(in the range). My recorded Macro is the following.
Sub Macro7() ' ' Macro7 Macro ' ' Keyboard Shortcut: Ctrl+q ' Range("A4706:B4710,A4761:B4765,A4816:B4820,A4871:B 4875,A4926:B4930,A4981:B4985,A5036:B5040,A5091:B50 95,A5146:B5150,A5201:B5205,A5256:B5260,A5311:B5315 ,A5366:B5370").Select Range("A5366").Activate End Sub I need this to do these steps allllll the way to the ending range of A141151:B141155. Obviously i don't want to write it in the single line single range form shown I need a "loop" process and then i need to apply the (+55 select 2x4 block and +55 select 2x4 block) formula. Please help i KNOW VBA can do this i just don't know how to tell it to |
#2
|
|||
|
|||
Hi
Please re-post in the programming section and I am sure someone will respond. Good luck. Tony |
Tags |
do loop, formula, vba excel |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Very simple formula needed! | nicholes | Excel | 4 | 04-12-2012 08:28 AM |
Formula to select description when code is entered | Natasha | Excel | 1 | 09-25-2011 12:59 PM |
It has to be simple...formula | ClearSkies | Excel | 1 | 03-04-2011 01:06 PM |
Math Notes Templates | S-C-3-1-3 | Office | 0 | 10-15-2010 11:44 PM |
How do I embed a Math formula? | DMD | Word | 0 | 11-17-2009 12:37 PM |