Activating the next column cell from the last active cell

[teachMeExcel]

Hi, Can anyone here help me on how to code the following:

I would like to activate the right cell (Next Column) after the active cell without explicitly identifying the cell, For example, if my active cell is C7, i would like to activate the D7 next, of if the active cell is K27, then i would like to active cell L27.

[VBA Noob]

You should avoid selecting when possible so if you have to do something to the cell please explain some more.

otherwise try

Please Login or Register  to view this content.

Offset is saying 0 Rows but 1 column

VBA Noob

[teachMeExcel]

Thanks Noob,

I need to examine all the cells value from A1 thru BP1 to find a match from the string provided on a Userform. then once matched, I need to capture the entire population of that column and paste it to another worksheet.
example, if last used row is 75 and matchs were found in Column H, then I need to copy the column H1:H75 and paste this to worksheet #2 column A

[VBA Noob]

Maybe

Please Login or Register  to view this content.

Change the inputbox to your code for the form

VBA Noob

[teachMeExcel]

Thanks Noob,

Your the greatest !!!!