Saturday, December 8, 2007

excel VBA

VBA find the REAL last used cell - Tek-Tips
VBA identify UsedRange OR last/first column/row etc. Tek-Tips
VBA So where exactly do I put this macro code then?? Tek-Tips

VBA Tips A Pop-up Calendar for Excel

Pearson Software Consulting, LLC excel pages
Anthony's Excel VBA Page - Excel Tutorial - Excel Consultant - Excel Consulting
Range Object and Cells Property

Help and Tips on Excel MacrosThe Programming Tools

Testing Macros in the Visual Basic Editor for Excel

"Dell OpenManage Deployment Toolkit, Utiliity"

Introduction Dell OpenManage Deployment Toolkit Version 1.3 Command Line Interface Reference Guide
Query Active Directory for Information About a User
Searching Active Directory
Band-in-a-Box QuickStart Tutorial: 128k WMV .zip download
Making a New Song Arrangement

Creating Exchange Users with Excel (Part 1)

==========================================
Looping Through Cells in a Named Range
http://www.mindspring.com/~tflynn/excelvba.html
The following example loops through each cell in a named range by using a For Each...Next loop. If the value of any cell in the range exceeds the value of limit, the cell color is changed to yellow.
Sub ApplyColor()
Const Limit As Integer = 25
For Each c In Range("MyRange")
If c.Value > Limit Then
c.Interior.ColorIndex = 27
End If
Next c
End Sub

No comments: