I have a very simple task that I can't seem to get VBA to do. I have an external sheet that has monthly data in columns. Column A is Jan, B is Feb, etc.

On my current sheet I am attempting to switch columns (months) to have my sheet reflect the current month. I am currently doing a find/replace and switching column B with A. What I want is a cell that has the column ref in it (example cell A1=B for feb) I want to reference this cell and do a find/replace on a large set of data.

I can manually get this to work but VBA doesn't paste the copied value into the find/replace box, it puts in the real value of the cell that was used to set up the macro.

Any ideas?
Other workarounds?

Thanks