EXCEL-VBA column max [duplicate]

Question

What would the equivalent to this be for the horizontal/colum?

v = Sheets("Sheet2").Range("A65536").End(xlUp).Row

I am guessing this but do not know how to check

v = Sheets("Sheet2").Range("zz1").End(xlRight).column

I am basically trying to figure out the how many columns there are. I tried what I guessed but it is wrong

This is probably a duplicate of one of these: stackoverflow.com/questions/33545516/… stackoverflow.com/questions/11926972/… stackoverflow.com/questions/17730639/… — Alexis Olson
– Alexis Olson, Commented Aug 10, 2016 at 17:47

PartyHatPanda · Accepted Answer · 2016-08-10 17:49:20Z

2

To get the index of the last column in the sheet, use Cells(1,Columns.Count).Column

To get the last used Column, it is very similar.

Cells(1,Columns.Count).End(xlToLeft).Column

answered Aug 10, 2016 at 17:49

PartyHatPanda

7248 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Scott Craner Over a year ago

make sure you qualify the range object with the sheet. Sheets("Sheet2").Cells(1,Sheets("Sheet2").Columns.Count).End(xlToLeft).Column

PartyHatPanda Over a year ago

True, if the sheet to check the columns is not the active sheet. If it is, qualifying it is not necessary.

Alexis Moreno Over a year ago

Would this work as well for rows?

PartyHatPanda Over a year ago

You can use what you had above for rows. Cells(Rows.Count, 1).End(xlUp).Row

nhaggen Over a year ago

Very important: this works only if all rows have the same number of columns, otherwise it simply returns the number of columns in row 1. Replace the index 1 by the index of the longest row, or by the index of a specific row you want to check

Collectives™ on Stack Overflow

EXCEL-VBA column max [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related