I am trying to write a simple VBa code in Excel to loop down a list of formula values and copy the results as text to an adjoining cell.
Here is what I have:
' Macro2 Macro
' Keyboard Shortcut: Ctrl+l
Do While Len(ActiveCell) <> 0
Range("M2").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
The loop works because I have run the code without the Range("M2").PasteSpecial command. However, when I insert this clause, it stops at the first value in the list.