xrg

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"...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 =...

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()...

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...

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...

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...

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...

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...

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)...

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...