Code to select cell to the right of current cell.

So I use a macro to add column, selects column to the left of it, B in this case, move down till end, insert a 1 in the new column (at the bottom) which I later use to copy a new formula down

Please Login or Register  to view this content.

The Column should always be the same, but I can't garentee the rows will be, so I'm wondering if I can tell the macro to selection end down and go right 1 rather than the specific cell C2236 which codes in when I use the right arrow.

Thanks in advance for any help.

CDNcameron,

Give this a try:

Please Login or Register  to view this content.

Using select statements and activecell is bad practice. I would recommend learning how to avoid their use.