1. G

    Excel 2016 Bug?

    I am experiencing a replicable problem with Excel 2016. I've created an application, that will work flawlessly in Excel 2010, but not in Excel 2016. In the app, the user selects a workbook from which they will be asked to select multiple, seperate ranges. There's a form with multiple...
  2. P

    Skip if workbook2 not open

    Hi,can anyone help? I have a macro that calls a sub and then copies the data to workbook2. If workbook2 is not open I want to skip a certain part of the code so it doesn't error because workbook2 is closed. does anyone know of a line of code I can add within the macro to skip a certain part...
  3. P

    copy data from workbook1 to workbook2

    Hi can anyone help with a line of code to copy data from workbook1 sheet1 range ("A:AS") to workbook2 sheet1 range ("A:AS") Regards pwill
  4. V

    How to call and run a Macro (StatusV2) stored on Workbook1 onto Workbook2

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...
  5. P

    Copying Data to Another Workbook

    Hi can anyone help with a macro to copy a range of data from one workbook to another? I have rows of data on workbook1 sheet(Data) range A2:H that I want to copy to workbook2 sheet(Data). I need the data to copy to workbook2 in the same columns as workbook1 but continue the data to the next...
  6. M

    Auto Update with Vlookup or without Vlookup

    hi, I have huge data in 2 Excel workbooks, i have to fetch data from workbook1 to workbook2. Both files are on shared drive. i tried to use vlookup to fetch data from Worbook1 to Workbook2 but due to having huge data(round about 5000 raws, 50 to 60 columns ), Vlookup does not get refresh...
  7. A

    ThisWorkbook.Close SaveAs:=false

    Hi, I am using Workbook1. And from Workbook1 i open Workbook2 in read only mode ""Workbook2"), readonly = true because i am using workbook2 only for read purposes, i dont want to save it. but excel gives me warning to save the workbook. I have tried to put this command in...

Some videos you may like

This Week's Hot Topics