vba copy paste cell info

  1. M

    How to copy formula text ONLY from a cell then paste it into a cell in another workbook?

    Hi I'd like to copy the text of a formula in a cell, then paste that text into a cell in a different workbook, without the formula changing. I can't use 'copy' then paste special xl paste formulas, because the reference changes when the formula is pasted into the other workbook. What would...
  2. A

    Copy and Paste in VBA not working

    Afternoon all, Here's a piece of the code that I have: LstRow = Cells(1, 1).End(xlDown).Row Range("T2:T" & LstRow).Copy Range("G2:G" & LstRow).PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, skipblanks:=False, Transpose:=False Range("U2:U" &...
  3. H

    Copy/Paste Range Based on Cell Info

    I need to run a macro that looks at a cell to figure out how many rows down to copy. In other words, if the cell (a1) has "19" in it, then the selection b1:c<b>19</b> would be selected. I have the rest of the code figured out, thanks for your time!

Some videos you may like

This Week's Hot Topics