#1   Report Post  
Dennis
 
Posts: n/a
Default

Very nice Nick! Works great!! I wasn't even close. Thanx so much for the help.

Dennis
============


In article , "Nick Hodge"
wrote:
Denis

This should work

Sub Finale()
Dim iLastCol As Integer, x As Integer
iLastCol = Range("IV2").End(xlToLeft).Column
For x = 2 To iLastCol
Range(Cells(2, x), Cells(11, x)).Select
'your routines here
Next x
End Sub

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with loop Mike C Excel Discussion (Misc queries) 3 January 29th 05 02:31 PM
Looping Macro to Find and Mark Big Tony New Users to Excel 8 January 26th 05 09:07 PM
macro loop Helen Excel Discussion (Misc queries) 7 January 12th 05 02:42 PM
How to incorporate Loop feature Jim May Excel Discussion (Misc queries) 4 December 16th 04 11:41 PM
VBA Newbie: Help with Do Loop code Carl Excel Discussion (Misc queries) 3 December 2nd 04 07:04 PM


All times are GMT +1. The time now is 08:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"