Select from cell A to the last data (right position) but skip Blank Cell

[Jhon Mustofa]

hi all...

how to make macro code can work to select range in active sheet start from cell A "going to" right to the last data but skip blank cell
then copy too..then the file can save as .xlam (add in)
this basic code but i don't know make it

Please Login or Register  to view this content.

or other code

thank in advance..

john m

[jolivanes]

Try
Sub Maybe()
Range(Cells(1, 1), Cells(1, Cells(1, Columns.Count).End(xlToLeft).Column)).SpecialCells(2).Select
End Sub

[Jhon Mustofa]

Try
Sub Maybe()
Range(Cells(1, 1), Cells(1, Cells(1, Columns.Count).End(xlToLeft).Column)).SpecialCells(2).Select
End Sub

hi jolivanes, almost done
please, see my picture for comparingAttachment 698239
note:
1. if it's possible can adding code to select and copy simultance in single code
2. can save as .xlam (add in), running as add in

[jolivanes]

Please Login or Register  to view this content.

I don't know anything about .xlam files. There are lots of questions and hence answers on these sites. I just use Personal.xlsb for that.
To attach a workbook you'll need to go to the bottom and select "Go Advanced" and follow instructions.

[Jhon Mustofa]

hi jolivanes...sorry i'm missing it..
please, don't use copy code
i mean ONLY select NOT copy simultance
like my attachment picture

[jolivanes]

The code in Post #2 selects as requested.
Can't open your attachment in Post #3.
Attach files as mentioned in Post #4

[Jhon Mustofa]

here my attachment file

[jolivanes]

What happened to this "but skip blank cell"?

Just leave the "SpecialCells" part out.

Please Login or Register  to view this content.

[Jhon Mustofa]

hi...your code only work in row 2..
how to make it work in any row such as in row 3,row 15 ,row 100, etc...

[jolivanes]

How are you deciding which row?

[Jhon Mustofa]

my data not always in single row. sometimes select row 2 ,sometime select row 3, etc...can't default row

[jolivanes]

You're not answering my question.
What determines which row to select?
Now it sounds like you want to maybe select multiple rows. If so, which row will determine the last column?
Or do you select a cell in a row and select that one?

Select any cell in a row with data and run this macro.

Please Login or Register  to view this content.

[Jhon Mustofa]

hi.. i just select that one.
your macro code working well, that's i want it..
Perfecto..Thank you so much!!!

[jolivanes]

Glad to hear you have it under control
Terima kasih banyak and Good Luck