Matching Number Format to Another Cell

[alteredbeast]

Hi,

I'm looping through columns and for each cell in the column I loop through data on another tab to find a result. The result can vary in format with regard to the number of decimal places it can have depending on the information needed for each column. In row 3 is the low limit for that column and I want the format of the result for each column to match the format of the data in row 2 of that column.

The code I have so far is:

Please Login or Register  to view this content.

Am example of the sheet is attached as a slimmed down version .

Any help would be greatly appreciated.

[MatrixMan]

Can you not just copy then use PasteSpecial Paste:=xlPasteFormats from source to target when the match is found?

[alteredbeast]

Unfortunately the format at the source isn't always the same as what is needed. I might be able to pick it up from the limit row though. I'll give it a whirl.

[alteredbeast]

Sorted it. Used paste special formats as mentioned, just made sure the formats were set correctly in the cells used as reference.

[MatrixMan]

Excellent - glad you got it sorted with a simple approach