Range("B1").Formula = "=(""TPR""&" "&TEXT(profitloss!B3,"mmmm")&" "&YEAR(profitloss!B3))"
This is the code I am trying to run. I know i have to use double apostrophes in places but I am unsure where and I can't seem to get it to work.
Thanks![]()
Range("B1").Formula = "=(""TPR""&" "&TEXT(profitloss!B3,"mmmm")&" "&YEAR(profitloss!B3))"
This is the code I am trying to run. I know i have to use double apostrophes in places but I am unsure where and I can't seem to get it to work.
Thanks![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks