How to identify the Last row automatically while running a macro ?

[raju.r.083]

Hi all,
Hope everything is good.

I just recorded a macro and I need help from you guys in editing this program.

Steps that are followed:
1) Insert a new column beside (Just for my convenience, I call the new column name as Temp column) Column B.
2) Use "TRIM" command.
3) Drag it till the end of the row.
4) Paste the obtained result as Values.
5) Again Insert new column just right side of Temp column.
6) Use "LEFT" command (Number of characters taken as 6).
7) Drag it till the end of the row.
8) Paste the obtained result as Values.
9) Delete 'A' column & Temp column.

My Requirement is, last row number (Here, the last row is 355 but it will change everytime) will be changing everytime and I want that to be identified automatically and perform the above steps that are mentioned.

Can anyone help me on this ? Thank you for your patience in reading this request.

Recorded Macro:

Please Login or Register  to view this content.

Thank you in advance.
Raju

[Sintek]

Hi Raju

please be so kind and upload a sample file with a before/after scenario so that we can ascertain your requirements.

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[sweep]

Hi,

The last row occupied row in a column (B in your example) can be determined as follows

Please Login or Register  to view this content.

You can then insert that into your code....

for example this,

Please Login or Register  to view this content.

becomes this

Please Login or Register  to view this content.

Note - please edit your post so the the code is presented properly (between tags) - how to do this is described in the site rules.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[raju.r.083]

Hi All,

First of all I am really sorry for not following the rules that are mentioned.

And I am really thankful to all of you in guiding me to get the result based on my requirement.
Thanks a lot!!!!