This is a really basic question -
I want to use VBA to paste a string of text, which is an excel formula, into a cell.
For example, I wan to create a macro that pastes "=IF(AND(SUM(L94:O94)>0,D94=""),1,0)" into cell E30.
What is the syntax I should use?
Also, for questions like these is there a good syntax reference that anyone would recommend?
Thanks!
Andrew
Bookmarks