Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2013, 01:12 PM
Jo-NathanBSChE Jo-NathanBSChE is offline A simple select for a given math formula Windows 7 64bit A simple select for a given math formula Office 2010 64bit
Novice
A simple select for a given math formula
 
Join Date: Apr 2013
Posts: 1
Jo-NathanBSChE is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 04-16-2013, 03:10 AM
OTPM OTPM is offline A simple select for a given math formula Windows 7 32bit A simple select for a given math formula Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Please re-post in the programming section and I am sure someone will respond.
Good luck.
Tony
Reply With Quote
Reply

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
A simple select for a given math formula Formula to select description when code is entered Natasha Excel 1 09-25-2011 12:59 PM
A simple select for a given math formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft