Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding the far-right column in excel
Message
From
01/10/2002 07:47:09
Alan Popow
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Finding the far-right column in excel
Miscellaneous
Thread ID:
00705926
Message ID:
00706294
Views:
28
>Alan, Thanks Steve
>its
>num_cols = o.Application.ActiveSheet.UsedRange.Columns.Count
>this_row = "a1:"+chr( 97 + num_cols -1)+"1"
>o.Application.Range(this_row).Select

Excellent.

Alan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform