| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOP BETWEEN "FRONT" AND "END" SHEETS?
Hi Lonnie,
Dim WS As Worksheet For Each WS In Worksheets If WS.Name < "Front" OR WS.Name < "End" 'Code to insert data End If Next This will add the info to any sheet, because 1. the If clause always yields true (needs to be AND, not OR) 2. Sheets before and after Front and end are also accepted. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
