Having problems copying a formula into a column. The first formula in the code below copied fine into column A. Getting errors when I added another formula to copy into column B. Not sure why. Do I need to change the formulas in column A to values first before putting the formula into column B that references column A? I tested the formula and it works fine when I manually copy it in to a cell in column B. Thanks!!
Please Login or Register to view this content.
Wherever you have quotes, apart from at the beginning and end of the string (formula), you need to double them up, as in your first formula.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I doubled up the quotation marks within the formula, but I still get a syntax error with the second formula. Code was changed to the following:
Please Login or Register to view this content.
maybe so
Please Login or Register to view this content.
That did it! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks