vab code

  1. J

    Cannot run VBA code in Excel 365

    Hello, I have this VBA code written in the "ThisWorkbook" section of my excel file to list the filenames from a folder: On Error Resume Next Const WINDOW_HANDLE = 0 Const BIF_EDITBOX = &H10 Const BIF_NONEWFOLDER = &H200 Const BIF_RETURNONLYFSDIRS = &H1 Set objShell =...
  2. I

    .End(xlUp).Row + 1 not finding the last used row

    I'm trying to enter data into two sheets at once. Everything works fine except in the sheet 2, it doesn't put data on the last used row, which should be A2. Instead, it keeps adding data from A13 and below. I deleted everything in the sheet and when I enter the data, it goes to A14, repeat the...
  3. C

    How to modify code to scrape data on a daily, weekly and monthly bases on websites

    Hello Excel supporters... I am not sure if Worf or anyone in this forum can help me. Below I have a file & code to scrape data from many links in investing.com The trouble I am having is this: On the web page. There is a "Time Frame" box list: Daily, Weekly & Monthly. However, inspect the...
  4. handri

    VBA prevent wrong item being scan

    Hi, I have a cell start from C7 to C10001. The data here is between PASSED and WRONG. which i created a simple barcode scanner purpose. How i can use a VBA code to stop scanning purpose if WRONG item scanned in the cell(C7 to C10001) Also a popping error message tell that you scan a wrong item...

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