How to write VBA to copy and paste special from one column to another column with 1 Criteria

[kitsa]

Hi,
I'm struggling to write a VBA for criteria "S" or "V" in Column ("C:C"). If value is True? Move Column ("H:H") to Column ("I:I") as paste special. From "Sheet1" or "ESS Inv Data Entry" sheet.
Can someone help me write this?

 

[kitsa]

Just curious, what do you mean by it stops at End If ?

When I run the VBA, it debug and stop at that point. Does that make sense?

 

[kitsa]

Just curious, what do you mean by it stops at End If ?

When I run the code it debugs and doesn't allow me to go further when it hits "End IF" code

 

[Alex Blakenburg]

What is the exact error message?
And can you show me the code you are running ?

 

[kitsa]

What is the exact error message?
And can you show me the code you are running ?

Sorry I apologise, but I re-done the VBA and it worked this time.

 

[Alex Blakenburg]

Thanks for taking the time to follow up on this when you already have something that works for you.
It is good practice to have consistent formatting and formulas within a single column of data. By applying the number formatting on a cell by cell basis while applying criteria and using Paste Formatting, it is possible (even likely) that all cells in the same column are not formatted consistently.