vba/macro

  1. A

    VBA/Macro - Move forlder

    Hi guys, I have a code below that I'm currently working on. This code should move folder to another destination. But for some reason, the code moves the files inside the source folder, not the source folder itself. Sub MOVE_FOLDER() Dim FSO As Object Dim sFolder As String, dFolder As String...
  2. A

    VBA/Macro - Dynamically add hyperlink

    Hi, Can anyone help with this: Data range: Range (A2) to last row in column G Worksheets: Main - SUMMARY (column H is where i'll put hyperlink - with header) Other worksheets Criteria for address: 1. column I (my helper column) of SUMMARY equals Worksheet name (select) 2. Value in column A...
  3. A

    VBA/Macro - Export Worksheet w Criteria

    Hi Guys, Criteria = all range ("H2:H" & LastRow) has values (nothing is blank). Inclusions = all worksheet except worksheet("Summary") What will happen: All this should only happen once there is a worksheet that meets the criteria. 1st Step = Move sheet that meets the criteria to a new...
  4. A

    VBA/Macro - Loop through worksheets

    Hi, I have a code below that I'm currently finishing. This code will update several columns on all worksheets whenever a new data is added. But it doesn't seem to be working. Hope anyone can help me. Thanks in Advance Sub UPDATE_SUMMARY_WB() Workbooks("Cummulative WHT...
  5. J

    Data Validation - Character Limit & Uppercase Only

    I am trying to set the character limit of my cells to 28 and force the characters to be uppercase using Data Validation so the user receives an error if either condition is not met. I have the uppercase portion working fine, but cannot seem to get the length to function correctly. It seems Excel...

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