Macro to Range Value specific columns

[Howardc1001]

I have a macro to copy data in B9:M9 and to paste these as values in B9 onwards


Where “Current” appears in row5 for e.g. B5, then the column containing Current must not be copied and pasted as values. In this eg only C9:M9 to be copied and pasted as values in C10 onwards


It would be appreciated if someone could kindly amend my code

Please Login or Register  to view this content.

I have also posted on https://www.mrexcel.com/board/thread...-data.1149818/

[Kaper]

Seems it is now solved (or well on the way) at MrExcel.
So please mark thread here as SOLVED