I need help cant wrap my head around this, trying to link cells together and I cant get the function to work
ActiveCell.FormulaR1C1 = "=Sheet2!R[-Cnt]C"
The 2 also needs to be the variable Cnt but it's the middle of a string so don't know if this is possible?
ActiveCell.FormulaR1C1 = "=Sheet2!R[-" & Cnt & "]C"
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
thank you for your help
this is what i got
ActiveCell.FormulaR1C1 = "=Formatting" & Cnt & "!R[" & Cnt & "]C"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks