xrg

  1. I

    Copy files from one folder to another based on a list in Excel

    Hello I'm very new to VBA , at the moment I'm using the following code to Copy files from one folder to another based on a list in Excel, and it work perfect what I'm looking for is instead of search in on folder is also search sub-folder <tbody> <code class="vb keyword"...
  2. P

    Advice with VBA Code to Move Files

    Hi there, I wondering if there is somebody out there who can help me with a macro to move files. I have a Excel list of files which have the full path and filename in column A, which has been obtain from a Windows search. What I am trying to do is move these files form there various folder...
  3. A

    VBA search subfolder and move to another folder

    Hi All, Long time lurker but first time poster. I have a scenario where I'd like to use a list in Excel to search for and copy the corresponding files to another folder. I believe I have most of the code written and it seems to work fine except for two small issues. One issue is that I need to...
  4. G

    Help with Encryption Code

    Hi all, Im not sure how this code works completely i found it using google, there is 3 different parts to it. 1st part is a Private Function as is the 2nd Part, The last part is just a Sub.. The code all works fine and does exactly what it is ment to do Encrypt Alphnumeric and special...
  5. A

    Split Cells using delimiter(s) to multiple columns in VBA

    Hi, I hope you can help me out, I'm pretty new to VBA coding and the code below works great for Spliting Cells using a single delimiter to multiple columns. However, I was hoping to modify the code so it would allow me to Split Cells using more than delimiter to multiple columns in VBA, such as...
  6. C

    Copying Files From One Directory to Another

    Hello, I'm trying to find all files in a directory a which match via a partial string with the value in column A, then copy them into a new directory. I've found code that does this but only for a specific file name (1110313_a.jpg). We'd love it if the script would find any files that contain...
  7. T

    Auto insert date in two cells problem

    Good afternoon, I am really rubbish with VBA so please forgive my code errors. , I have a worksheet where I have a drop down list (A), once selected it puts the date and time in a cell, 2 cells to the right(C). In the same Row I have another cell(F), that if data is present, it puts the time...
  8. C

    Set name of worksheet in vba

    Hi everyone I have been using the below code to automatically hide rows based on if a cell is = 0. This works fine as I'm hiding the data on the same worksheet, but now I am using the button on my main worksheet but want to hide rows on another worksheet called 'Hidden' in the same workbook...
  9. G

    Auto add date in adjacent cell when data inputted

    Hi All. I have the VBA code below whereby when data is entered into a cell in column C for example, the date that the info is entered is automatically entered into the cell in column B. I would like to replicate this for columns C:V. I have changed the code to C:V instead of C:C but it enters...
  10. C

    Macro validation before running

    Hi guys Hoping a genius can help me with a quick check before running through a macro... My vba below works perfectly, however can someone please help add some validation before running my macro that does the following check: Cell C9 must contain either the text "RP2000" or "RP5000" Cell C11...
  11. S

    Showing/Hiding Columns

    Hi, I have a script that searches for a specific name in the first cell of every column and hides or shows an entire column when there's a match. It works just fine while there're no filters applied to any of the columns, in which case it does nothing. How can I fix this? Private Sub...
  12. T

    Bulk insert images and want to lock aspect ratio

    Hi, May I know how to lock aspect ratio by editing below code? <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}</style>Sub InsertPicFromFile() Dim xRg As Range Dim xCell As Range Dim xVal As String On Error Resume Next Set xRg =...
  13. Y

    excel SORTING HIDING WITH VBA

    hello i have a code that works fine but id like to adjust it to add another criteria. I want to hide rows in Column "F5:F171" if they read "Inactive". It is currently hiding based on Yes/no in Column G just fine . I just want to hide based on 2 conditions. Thanks Sub sort_updated()...
  14. A

    how do i make the formula so that if the other cell is changed then send an email also with a different recipient

    Hi I just learned VBA, I made code like this Dim xRg As Range 'Update by Extendoffice 2018/3/7 Private Sub Worksheet_Change (ByVal Target As Range) On Error Resume Next If Target.Cells.Count> 1 Then Exit Sub Set xRg = Intersect (Range ("c4"), Target) If xRg Is Nothing Then Exit...
  15. I

    Newbie Needing Help - Macro will only work in one sheet.

    Hello, I'm not familiar at all with using VBA so please bear with me. I am trying to get the below code to work on all the sheets. It works on Sheet 1, but not the rest within the same workbook. I've read another thread w/ similar question, but the codes are so different I don't even know...
  16. S

    Code to select column and insert border at each change in data

    Hi Guys im after some code that can add a border to the end of the change in data but defined by a specific column. so in theory it would open a message box to determine the column to look down and at the end of each change in data insert a border. The border would be from A:N for example I've...
  17. S

    Save previous cell VALUES and not only the last one.

    I found this interesting code that is almost perfect for my needs. When a cell changes value, this code save the old value in another cell. The problem is that when I change it again, it overwrite the previous "old value". So, at the end, I only have my "N value" and my "N-1 value". What should...
  18. H

    Worksheet change event to triger only if a specific cell value changes

    Hi friends, I am using the below code to hide unhide rows based Private Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Unprotect ActiveWorkbook.UpdateLink Name:= _ "\\192.168.0.100\itex Share\ITEX\DATA ENTRY.xlsm", Type:=xlExcelLinks Dim xRg As...
  19. P

    Populate textbox after combobox selection template doesnt work for me

    Hey all, I have my work cut out with this excel-file at work that I promised I could handle. Well I can, I just need your help again again again! :) I'm having difficulties populating a textbox after they select or write a number in to a combobox (it's a simple postcode and city situation)...
  20. J

    move entire row containing a target value

    Hello, I've been able to find solutions that are close, but not exact I need a macro that will autorun when the spreadsheet ("data") opens and looks for a target value ("no"), then moves (not copy) the rows that contain the target to another sheet ("Has_No"). The code below only looks for...

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