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
Saturday, December 8, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment