vba macro 2016

  1. U

    VBA: Add blank cells based on Specific date

    Hi Gurus, Can you share your idea on how to automate this? I have below data usually long set. Account Country Score Date 1 France 1000 09/30/2021 2 Norway 500 05/31/2019 I wanted to separate and add 2 blank cells if the date is more than 1 year. Let's say macro will ask for...
  2. G

    VBA Macro stop

    Hi I have a windows task job that start excel workbook and execute some function in a private open workbook() . I would like to have a message on the screen when workbook open saying (press space bar or any key to stop execution) , that one look sample, but i need a loop or something to...
  3. S

    How to split text into Columns, Data is with no space in between words and numbers

    Hi Friends, I been trying to split text into columns but did not find a suitable post over here. Here is the sample file with data extracted into columns Manually, its taking long human hours to complete. https://spaces.hightail.com/space/OU0YRqc7Yl I do not know if it is possible with...
  4. A

    For lRow = 353 To 2 Step -1 what does this mean

    I am using this bit of code in my macro I found to nearly work but could someone please tell me what this means For lRow = 353 To 2 Step -1 does it only go down to row 353? I want it to work on columns B & C only, thanks The full code is: Dim lRow As Integer Dim intCol As Long Dim rngCell...
  5. D

    VBA to consolidate files

    Hi all, i have multiple similar files from different countries to be consolidated by me, i want a VBA to consolidate the data from single files to a consolidated file. below are the basic requirements. Source File name:- file1 to file 15. Destination file name:- consol File. Source sheet...

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