Content added Content deleted
imported>DrOwl (some VBA Notes) |
imported>mutante mNo edit summary |
||
Line 1: | Line 1: | ||
Some usefull snips of Excel VBA that i use. |
Some usefull snips of [[Excel]] [[VBA]] that i use. |
||
Line 29: | Line 29: | ||
</pre> |
</pre> |
||
[[Category:Software]] |
|||
[[Category:Programming Languages]] |
|||
[[Category:Scripts]] |
Revision as of 17:34, 5 September 2005
Some usefull snips of Excel VBA that i use.
work with multiple Worksheets
this macro will Loop through all work sheets doing X... i found this on utteraccess this thread
Public Sub UpdatetoNextWeek() Dim w As Excel.Worksheet If MsgBox("Update the week and period details?", vbYesNo + vbQuestion, "Confirm update") = vbYes Then For Each w In ActiveWorkbook.Worksheets w.Range("H9") = w.Range("H9") + 1 w.Range("F9") = w.Range("F9") + 7 Next w MsgBox "Done", vbOKOnly End If End Sub