VBA to select range: End(xlup)-->End(Xlright)..?

**mchilapur** · 02-25-2017, 08:45 AM

Dear all,

I have been using below code to select a used range in any column and i found it to be more effective.

Please Login or Register  to view this content.

Now i am need of similar code to select used range in a row..? Something similar to this..

Please Login or Register  to view this content.

but this doesnt work.

Please suggest how can i modify it.?

**AB33** · 02-25-2017, 08:55 AM

Rows FIRST and then TURN LEFT

ActiveSheet.Range("B2", ActiveSheet.Cells( 2,Columns.Count).End(xlToLeft)).Select

**Winon** · 02-25-2017, 08:57 AM

Also even this would work,

Please Login or Register  to view this content.

**mchilapur** · 02-25-2017, 09:00 AM

@AB33: Correct...But it still throws an 'Object defined error'..

**mchilapur** · 02-25-2017, 09:01 AM

But i want to make this dynamic selection..

**AB33** · 02-25-2017, 09:02 AM

xlright should be xlleft

**mchilapur** · 02-25-2017, 09:05 AM

YEs yes...It must be xlleft...
You nailed it down... Thanks for your advise...

Re: VBA to select range: End(xlup)-->End(Xlright)..?