Macro that pastes a copied string into the FORMULA of the active cell
Posted on 2011-04-22
I need something that will say in effect : ActiveCell.Formula = whatever string is currently in copy memory.
I'm copying from an external PDF file, and I find that if I select a cell and paste as usual, Excel distributes it to 2 or 3 cells, one for every line skip, whereas I need the entire string in one cell. But if I select the cell and paste into the formula bar, then I get it all in the one cell. Like this:
ActiveCell.FormulaR1C1 = "E" & Chr(10) & "1035622"
How do I do that in VBA?