pastespecial=xlvalues

  1. S

    Paste special not working - sending me to debug

    Code is below, can anyone tell me why paste special is not working...? I use this same code with xrange and it works fine, then I try to copy paste another set, and I get an error when it gets to Selection.PasteSpecial xlPasteValues LastRow = Cells(Rows.Count, 1).End(xlUp).Row 'Gets...
  2. P

    How to copy only the visible line of Autofilter and paste only values

    Hi, I've been trying to work with my excel data where I need to copy data from one sheet to another sheet. In the source sheet I have the following data Doc nr (A) Date (B) Name (C) Nr (D) Cost (E) Amount TCY (E) Currency (F) Description (G) Amount LCY (H) Account2 (I) 5646546 31100...
  3. D

    VBA alternative to copy paste syntax that doiesnt use paste .... clipboard popup

    Hi, if i use the current syntax with this macro i get an annoying "clipboard has a lot of info on it" popup. To avoid it i would like to use the non paste method, but i cant figure out the appropriate syntax for the situation. Thanks for any help. This is the code section in question...
    • Davavo
    • Thread
    • cells dim excel 2016 vba lastrow and range pastespecial=xlvalues
    • Replies: 3
    • Forum: Excel Questions
  4. B

    VBA Run-Time Error in loop for pasting range values from one workbook to another

    WHAT I'M WORKING WITH: I have two workbooks, MacroTestingSheet2.xlsm is the source, and Target.xlsx is the destination. MacroTestingSheet2.xlsm has several worksheets in it that serve as the data source for the rest of the worksheets. Target.xlsx is a copy of all the remaining worksheets...
    • bardophile
    • Thread
    • error loop and copy paste value macrotestingsheet2.xlsm pastespecial=xlvalues worksheets
    • Replies: 1
    • Forum: Excel Questions
  5. S

    For Loop not entering into body of loop

    Greetings, I am having trouble with a For Loop. Everything above the For RowLoop1 = G to I line appears to be working well. I have been running it line by line with F8. At the line For RowLoop1 = G to I the code proceeds to go directly to the line K = K-1. I am not sure why the script is not...
    • SBF12345
    • Thread
    • dim e.value integer pastespecial=xlvalues rowloop1
    • Replies: 2
    • Forum: Excel Questions
  6. S

    Variables on Add Watch shifting from non-zero value to "0" at integer variable assignment line

    Greetings, I am beginning to run the script below line by line with F8. I am watching the different variables with Add Watch. When I get to line: A = E The value of A goes to "0" and creates errors for the subsequent variable values that use A as an independent. Any ideas why A goes from...
    • SBF12345
    • Thread
    • dim e.value integer pastespecial=xlvalues selection.paste
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top