Count columns

[EnergyEngineer]

How can I count the number of used columns in a specific row? The below code doesn't work.

Please Login or Register  to view this content.

[VBA Noob]

This will found last used column for activecell

Please Login or Register  to view this content.

assumes it's not xl 2007

VBA Noob

[EnergyEngineer]

I used this and it worked. Thanks!

Please Login or Register  to view this content.

[royUK]

I used this and it worked. Thanks!

Please Login or Register  to view this content.

Does it work with the speech marks around 71?

[VBA Noob]

Glad it helped.

Just a tip. You can use the VBA recorder to give you

Please Login or Register  to view this content.

Where selection is a cell in the last column then mod as required

VBA Noob

[EnergyEngineer]

Yah I noticed that and I just fixed it. It worked but I took it out since it was extra.

Thanks,
~RUTH~

[EnergyEngineer]

Thanks but I needed the count for a loop.

~RUTH~

[VBA Noob]

I meant use the recorder to give you the direction then tweak. So change selection with your ref and last column

hope that makes sense

VBA Noob

[EnergyEngineer]

Yah I got it. Thanks! The macro recorder is pretty nifty. Sometimes I like to figure it out the hard way.

~RUTH~

[Ron Coderre]

I used this and it worked. Thanks!

Please Login or Register  to view this content.

Does it work if there's a value in Col_256?

Try something like this:

Please Login or Register  to view this content.

Does that help?

[VBA Noob]

Hard way being the forum

VBA Noob

[EnergyEngineer]

No I don't think I will ever have something in column 256. Thanks for the debug thought.

~RUTH~

[VBA Noob]

If you select cell say A256 and you press Ctrl + left arrow it will take you to either A1 if no cells filled in or any cell that has a value.

When you record this action you get

Please Login or Register  to view this content.

Then change selection as you did to

Please Login or Register  to view this content.

Your row and last column of spreadsheet

by changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

you return the column number

HTH

VBA Noob

[EnergyEngineer]

Yah yah I understood what you were saying. Thanks for the detailed explanation.

~RUTH~

[VBA Noob]

Good to hear.

However I thought I should explain as your comment below seem to me that you didn't understand

No I don't think I will ever have something in column 256. Thanks for the debug thought.

~RUTH~

VBA Noob

[EnergyEngineer]

That was in response to Ron and his thought if there was something in cell 256.

~RUTH~