Posted to microsoft.public.excel.programming

external usenet poster

Posts: 96

Can I loop this?

.....or is there a better way to write this?

Private Sub CB1_Click()

With ThisWorkbook.Worksheets("February")
.Range("B5").Value = Worksheets("020110").Range("B5").Value +
Worksheets("020210").Range("B5").Value

End With
End Sub

The Worksheets go from "020110" to "022710"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
returning back to loop check condition without completing the loop	ashish128	Excel Programming	13	April 3rd 08 12:53 PM
Loop to Filter, Name Sheets. If Blank, Exit Loop	ryguy7272	Excel Programming	3	February 5th 08 03:41 PM
Naming Worksheets - Loop within a loop issue	klysell	Excel Programming	5	March 29th 07 05:48 AM
Advancing outer Loop Based on criteria of inner loop	ExcelMonkey	Excel Programming	1	August 15th 05 05:23 PM
Problem adding charts using Do-Loop Until loop	Chris Bromley[_2_]	Excel Programming	2	May 23rd 05 01:31 PM

All times are GMT +1. The time now is 01:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us