Hi,
I am facing problem with cell formula to capture in macro, complete formula not populating while recording macro.
Lines are disconnecting, (Ex: In code one of the lines has "CONCATENATE(LEFT(R2,33)" , it's coming as "CONCAT"& _" but in next line there is no continuation)
Attached is the formula and output macro code. Is there any limitation on cell formula lines? even if i changed continuously without spaces it's not working.
I am using 2010 excel, please help me on this.
Thanks
Bookmarks