For a while now I have been using some code to determine how far down a
worksheet the last line of data appears. For example:

With ActiveSheet
lngLastRow = .Range("A65536").End(xlUp).Row
End With

Does anyone know the equivalent function to count how far out from the left
(i.e. if there is data in columns A to G) - I'm sure it must exist but
cannot quite figure it out.

thanks

check out the specialcells method - XLLastCell would POSSIBLY give you the
data you want?
"Graham Whitehead" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> For a while now I have been using some code to determine how far down a
> worksheet the last line of data appears. For example:
>
> With ActiveSheet
> lngLastRow = .Range("A65536").End(xlUp).Row
> End With
>
> Does anyone know the equivalent function to count how far out from the
left
> (i.e. if there is data in columns A to G) - I'm sure it must exist but
> cannot quite figure it out.
>
> thanks
>
>
>

lngLastCol = .range(1,Columns.Count).End(xlToLeft).Column

based upon row 1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Graham Whitehead" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> For a while now I have been using some code to determine how far down a
> worksheet the last line of data appears. For example:
>
> With ActiveSheet
> lngLastRow = .Range("A65536").End(xlUp).Row
> End With
>
> Does anyone know the equivalent function to count how far out from the
left
> (i.e. if there is data in columns A to G) - I'm sure it must exist but
> cannot quite figure it out.
>
> thanks
>
>
>

Thanks Bob.

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:eCF9n$(E-Mail Removed)...
> lngLastCol = .range(1,Columns.Count).End(xlToLeft).Column
>
> based upon row 1
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Graham Whitehead" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> For a while now I have been using some code to determine how far down a
>> worksheet the last line of data appears. For example:
>>
>> With ActiveSheet
>> lngLastRow = .Range("A65536").End(xlUp).Row
>> End With
>>
>> Does anyone know the equivalent function to count how far out from the
> left
>> (i.e. if there is data in columns A to G) - I'm sure it must exist but
>> cannot quite figure it out.
>>
>> thanks
>>
>>
>>
>
>