Help in selecting variable range while creating macro

I need a help in selecting range while creating a macros. My requirement is I have recorded a macro which should work in any selected column the range it should select is from the previous column last data row to the top. In the below macro the problem is it is selecting the entire column and data is filled in the entire column from K3:K1048576. Please help me to fix this and it should work in any column.

Please Login or Register  to view this content.

Hello Nayaz79,

Welcome to the Forum!

While recorded macros are easy to create, they are not flexible, fast, or easily modified. It appears that you are adding conditional formatting to range of cells based on the ActiveCell.

The big problem with using End(xlDown) method is when the cell is blank and there are no other cells with data below it. The range will extend the full length of the column.

Another problem is if the cell is in column "A", the macro will throw an error. This macro would benefit from being rewritten.