rohitnigade
New Member
- Joined
- Oct 7, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- MacOS
Hi,
I'm facing runtime error 1004 when using the below command in excel. What could be the reason? The variable is defined as a string and has a value taken from another cell.
ActiveCell.FormulaR1C1 = "=RIGHT(LEFT(" & Variable & ",8),1)&RIGHT(LEFT(" & Variable & ",6),3)"
I'm facing runtime error 1004 when using the below command in excel. What could be the reason? The variable is defined as a string and has a value taken from another cell.
ActiveCell.FormulaR1C1 = "=RIGHT(LEFT(" & Variable & ",8),1)&RIGHT(LEFT(" & Variable & ",6),3)"