Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - ClearContents All Rows Except 1st - How??
Message
From
15/01/2002 08:19:29
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
 
 
To
14/01/2002 16:00:30
Gary Wynne
Melrose
Manchester, United Kingdom
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Excel - ClearContents All Rows Except 1st - How??
Miscellaneous
Thread ID:
00604582
Message ID:
00604784
Views:
18
>Maybe, another question is how do you establish the last cell of the last row in the ActiveSheet so that I can create a range from A2 to the last cell of the last row.

Check out the UsedRange property of Worksheet. It references a range that contains only the part of the sheet that's in use.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform