Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a functional difference between Debra Dalgleish's code for this at:
http://www.contextures.on.ca/xlfaqApp.html#Unused And this: Sub ResetUsedRange() Dim i As Integer, j As Integer Dim w As Worksheet For Each w In ActiveWorkbook.Worksheets i = w.UsedRange.Rows.Count j = w.UsedRange.Columns.Count Next w End Sub I don't use UsedRange that often. When I have used it, both procedures give my identical results. Just curious. -- tj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
usedRange | Excel Programming | |||
usedrange | Excel Programming | |||
UsedRange | Excel Programming | |||
Help - How do I reset usedrange in excel 2000 | Excel Programming | |||
Usedrange | Excel Programming |