i.copy

  1. G

    move sheets to a new wb w/ criteria

    Hi Guys, I need ideas on how to move sheets from 1 db based on a criteria in 1 sheet to a new wb. Below is my code. The challenge with the below code is it is not sustainable, if there's a new condition, I would copy over the whole code to create another If and Then command. Thanks! Option...
  2. G

    Adding data from Excel to Word throwing a run time error

    Hi Everyone, Here i have tried with some data that should be added from Excel to Word, later convert from Excel to Word and Good thing is that below code runs, but after executing with some sheets it throws me a run time error and code exits Can anyone help me to solve this out Below is my...
  3. G

    Need help to convert Excel to Word

    Hi Everyone, Here i am trying to convert data's from excel to word as a letter format but as i debugged and checked, from the highlighted line the code is skipped. Can i know what wrong i have done/what changes i should make???? https://app.box.com/s/ylrujmxp79v84m0ejc50jw7spheo8a1y In above...
  4. S

    VBA Explorer keeps showing closed workbooks macros

    As the title suggests, after closing another workbook that runs a macro it keeps showing up in the VBA Explorer. Every time I run the macro a new instance of the closed workbook is showing up in the VBA Explorer. What the macro is doing: *Open a template workbook *Copies data to it from the...
  5. W

    Run-time Error '1004': Application-defined or object-defined error.

    Dear Gurus, The above-mentioned error keeps popping up when I execute the code below. It was running perfectly fine till I switched the sourceWB workbook and made changes to the code to reflect the change. Since the change, i could not get the macro to run and it is driving me crazy. Hope...
  6. J

    vba code to correct

    Dear sir, I have a vba code that is working nice but problem is that while importing data, font size, conditional formatting etc.....is also importing along with............so please I want value to be imported to the next worksheet.............and for your king refference.........i am sending...
  7. D

    Speed Up Macro: Populating tabs based on a variable

    Hello, I have a spreadsheet that puts a stock into a specific tab depending on its industry. The trouble I am having is that I sometimes have 2000 stocks this has to cycle through and it takes a significant amount of time. If anyone can think of a way to speed it up I would appreciate it. Code...
    • dnicholsby
    • Thread
    • 0.pastespecial elseif i.copy i.offset0 paste=xlpastevalues
    • Replies: 11
    • 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