Column Count + Offset

[weeeee0713]

Hi guys anyone has a sample code using column count and then followed by offset?

For example: See attached picture, I want to find the last column with data on row 2, then once I selected the last column it will shift or offset to the next column.

Thanks. Pls help.


Capture.JPG

[Kaper]

For example

Please Login or Register  to view this content.

If it's not enough then suggested reading: http://www.excelforum.com/forum-rule...rum-rules.html fifth and fourth point in "Want to get your question answered quickly?" section.

[Olly]

Please Login or Register  to view this content.

You don't say what you want to DO with that range, but this example shows you how to find it.

[sktneer]

Not sure what you are trying to achieve. But to give you an idea try something like this.....

Please Login or Register  to view this content.

[weeeee0713]

Thanks sktneer. your example solve my problem thanks.

[sktneer]

You're welcome. Glad I could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.