General information
Category:
Coding, syntax & commands
Absolutely right. I know UsedRange only gives you the 'Used Range', but the truth is the ramifications of it never even entered my mind in my reply to you.
Just one of those considerations, I guess, that doesn't bubble up to the surface when the problem isn't one of my own sitting in front of me.
Nice catch.
Alan
>Hi Alan,
> One additional word of warning on this. If the first column that has data is NOT the first column in the sheet then that code won't work exactly right. For example, if column 1 is empty, and columns 2 - 10 have data, then num_cols would return 9, and this_row would be "a1:i1" when what you really wanted was "b1:j1".
> Using o.Application.ActiveSheet.UsedRange.Column will return the value of the first USED column in your excel sheet. Therefore your 'this_row' variable would become:
>
>begin_col= o.Application.ActiveSheet.UsedRange.Column
>this_row = chr( 97 + begin_col - 1 ) + "1:" + chr( 97 + begin_col - 1 + num_cols - 1) + "1"
>
>However, if you're sure your data will always begin in column 1, this point does not matter.
>
>Happy Excelling.
>
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only