Using named cells in VBA

I need some help.

H5 cell has "PELIC" in it. When it gets Concatenated with P or R I should get PELICP and PELICR which are the names of cells containing numbers.

In Excel this line is in cell G5
=F5-INDIRECT(CONCATENATE(H5 & "P"))-INDIRECT(CONCATENATE(H5 & "R"))
It runs just fine

Now I want to use this line in VBA Macro instead
Range("G5").Value = F5-INDIRECT(CONCATENATE(H5 & "P"))-INDIRECT(CONCATENATE(H5 & "R"))
But it does not work, I get this error

Compile error
Expected list seperator or )

Can you help me with this

Try this...

Please Login or Register  to view this content.

Originally Posted by pumper

Now I want to use this line in VBA Macro instead
Range("G5").Value = F5-INDIRECT(CONCATENATE(H5 & "P"))-INDIRECT(CONCATENATE(H5 & "R"))
But it does not work

Try [G5] = [F5-INDIRECT(CONCATENATE(H5&"P"))-INDIRECT(CONCATENATE(H5&"R"))] …

Thank you for all your help.
All 3 of the suggestions worked, I will use the one by Dante Amor. It's the fastest to write.

As far as what's in F5, just a number

Why was I using CONCATENATE(H5 , "P") etc. The original formula was in a cell not VBA, that's the way I was told to do it.

I am new to this as you can see, can you explain the use of [ ]?

See the VBA help of the powerful Evaluate method …