Hello,

I have 2 workbook. For simplicity sake, I call it destination and source workbook.

What I'm trying to do is simple, copy the formula that's in source workbook of sheet1 at a particular cell to the destination workbook.

My problem here is that:
1. Source formula bar has either a formula or a static value.
2. If it's a formula, there'll be either 1 of these 2:
2.1 Formula is a full path link i.e. \\network_name\network_folder\....\[workbook_name.xlsx]SheetName'!$A$1 <----This is what I desired
2.2 Formula is a full path link i.e. \\network_name\network_folder\....\[workbook_name.xlsx]SheetName'!$A$1-A100-B200


My question is, how am I able to check if it's formula or not?

If it's formula, I'd only want the full path that reference to that cell, in this case \\network_name\network_folder\....\[workbook_name.xlsx]SheetName'!$A$1.
If it's a static value, then take it as it is.

currently, I have (code below), but it's pulling the whole formula.

dst.Sheets("Sheet1").Range("A" & x).Formula = srcShtName.Range("A" & z).Formula