Home/ Questions/Q 15088
Next
Answered
computing
  • 10
Asked: 2021-12-17T16:01:02+00:00 In:

Solved VBA Formula To Carry Format With VLOOKUP

  • 10

Hi everybody

I have been trying to find my way around getting VBA to carry the format of the result when using VLOOKUP. I am novice in VBA and struggling with no success.
Would you be able to help me out with that?

Is there any other way to combine values(and formats) from two different datasheets without using VBA?

Thanks a lot

Share

    1 Answer

    1. Best Answer
      This thread seems to address the issue and provides some example code.

      I haven’t tried it yet so I can’t speak to whether it works or not.

      http://www.mrexcel.com/forum/showth…

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0