selection.paste

  1. V

    Selection.Paste Please tell me whst is the error in this code and how it can be corrected.

    Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+q Range("F11:F36").Select ActiveWindow.SmallScroll Down:=12 Range("F11:F36,F40:F48").Select Range("F48").Activate ActiveWindow.SmallScroll Down:=15 Range("F11:F36,F40:F48,F52:F53,F57:F61").Select Range("F61").Activate...
  2. C

    Macro for copying data from fixed cells, but pasting to different cells each time

    Hi, I am currently in the process of converting all of our files at work from Lotus 123 to Excel 2013. I need to create a macro which copies data from a number of different cells (which are always the same, i.e. the plot number will always need to be copied from sheet 'Plot Input' cell C2)...
  3. 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
  4. N

    Printing Excel Data into a MSWord document as formatted text, not a table.

    My boss is being difficult. Using some code I found on this site, I can have our status report Excel spreadsheet create a lovely MSWord document...but the data is in table format. She wants plain ole' formatted text. When I use " appWD.Selection.Pastespecial datatype:=wdpastetext" it comes...

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