VBA copy format challenge!

[MikeL]

Hi,

I am grabbing the .Value from a variable. How to copy formatting of cell above as well?
Shortest code possible as I have many lines of code like this.


wsSheet2.Cells(3,2).Value = TestSheet1



Thanks in advance.

 

[Norie]

Where exactly are you copying the formatting from?

Is it from the cell above the cell you are putting the value from TestSheet1 in or is it from the cell above the cell where the value in TestSheet1 has come from?