wsdest

  1. M

    Streamline quick VBA statement

    I have several worksheets in the same Excel file where I need to clear the contents in these specific columns (A,D,G,J,M,P,S & V) starting at row 2 in each column. My worksheets are named (8am, 12pm, 2pm, 4pm and 6pm) - Here is the code so far that clears these contents but it seems like I...
    • mssbass
    • Thread
    • contents ldestlastrow statement streamline wsdest
    • Replies: 5
    • Forum: Excel Questions
  2. M

    VBA Macros to Import Data to Another CLOSED Workbook

    Hi to Everyone, I have found this code online and modified to the best knowledge I know in VBA. I have two scenarios of copying and pasting data, the below is the first one. I want the DB_ForReference to be dynamic based on ActiveSheet.Range ("I1") as I want the user to be able to select...
  3. P

    XLtoRIGHT and Down - help

    Hi Please could you help with my code. Keep getting an error Sub test()' With Sheets("Logistics") Dim wsDest As Worksheet Set wsDest = Sheets("test") Range("C18", Cells(Selection.End(xlDown).Row, Selection.End(xlToRight).Column)).Copy wsDest.Cells(Rows.Count...
  4. Pinaceous

    VBA import file macro

    Hi All, I'm working with a great macro that allows the user to select a specific excel file in importing it into their already open excel workbook. Dim wsDest As Worksheet Set wsDest = ActiveWorkbook.Sheets(11) Application.ScreenUpdating = False On Error Resume Next With...

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