xrg

I would like some help to modify the code below to adjust row height and font size only down to the last row with data. Currently it adjusts the rows for the entire sheet which doesn't seem necessary. This code also hides both rows and columns based on various criteria. Is the code efficient...

The macro below was originally 2 separate macros, one to hide rows and one to hide columns. I combined them into the one below, but I was wondering if it should be written in a better way. Also, I use this same code in 7 other sheets where I just change the row and columns numbers. I made a...

Hello Excel/VBA Masters! I got a table and with info that needs to be verified by employee. Next to each row of information there is Data Validation list (Verified / Not Verified). I got formulas down that show the username and time+date of verification, than i i lock the cells if there is any...

I need to hide rows based on a cell value if blank or has a "-". I grabbed the code below online but I assume it can be improved. I do want the sheet name specified because I run this for several sheets under a global macro as well. Any help is appreciated. Thanks Sub CLUTCH_BUILD_HIDEROWS()...

I am using below code to extract & consolidate data from multiple sheets into 1 new sheet of same excel file. But this Macro copying all rows from all sheets. I want to extract only active data (want to stop extracting when there is no data (space/empty) in Column 'A', and move into next sheet...

Hi Everyone, I have a sheet that is set up like a form, I need people to fill the areas in one row at a time so I have a macro that locks the sheet which I run at the start. then I have this macro that unlocks the rows in need as the correct data is added. This all works great except if...

Hi all, Hope you're well. I'm sort of a journeymen VBA guy that can write macros if needs be, but I'm nothing special. I'm a little rusty right now, but I did a little research online and found this macro that finds a column, and then is supposed to format the column as a 'number' and...

Hi, I create basic Userform. In that, I want to load image based on Combobox / TextBox value. But image is not loading. Please go through the below code and Help me. Private Sub cmbimg_Change() Me.TextBox1.Value = Application.WorksheetFunction.VLookup(Me.cmbimg.Value, xRg, 2, False) End Sub...

I have a Userform with one combobox and 5 textboxes. The following code I have so far does everything I want except for one thing. If for example I select the name Paul in my combobox it shows all the pertaining data in the 5 textboxes but when I edit in textbox1 for example to change his phone...

I am having this problem I have Userform with 1 Combox and 5 textboxes. When for example I select an Item in the combox and say the 1st textbox changes to "090123". When I change the number to "090129" it does not change in the corresponding cell in my worksheet. Here is my code: Private Sub...

hallo all, I'm grateful of the help I found hier this a macro I need to transform (from kutools site) to stop when een empty cell is reached and begin again thanks in advance <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family: Consolas, "Bitstream...

I have an excel spreadsheet which identifies where image files need to be moved. At the moment all the image files are located in one large folder on my external hard drive f:\ So, I want to move all the images that correspond to the folder name which is recorded in excel spreadhseet I have...

I have been trying to create a VBA from command button that allows me to print all from a drop down list (one sheet per item on the drop down list). I am at this point but have an error and can't figure it out. Any help greatfully received Private Sub CommandButton1_Click() Sub...

I currently have a workbook that when data is entered in column A it will return a time stamp in column I with the help of the if statement. This works great however it makes my workbook very slowwwww. Is there another way or a VBA code that could do this same thing that could improve my...

Hello all. I found a code that will allow me to create the command button that will create multiple Outlook emails, 1 for each email in a different selected cell. What I need it to do is instead of multiple single emails, it would create just 1 single email with the multiple email addresses...

Hi all - I apologise in advance if I sound stupid. I would be very greatful if someone could tell me how to repeat the following macro multiple time to look at other columns..it if K populated put date in L, if N populate put date in O etc... Private Sub Worksheet_Change(ByVal Target As...

Ye I mean Blank not Black Hi I have used the below VB code and i can get it to work to hide blank rows on sheet 1 where the contents in A is blank However I need to get it to run for all pages in the workbook. of which there are 4 Private Sub Worksheet_Change(ByVal Target As Range) 'Updateby...

I've managed to get this code started, but am finding difficulty seeing what's going on here. The message box never occurs when the inputbox input is "". The selection delete part works, but anything past that does not execute. I've made several attempts at restructuring the if not to if else...

Hi All, I routinely have a column of data which is quite lengthy with each cell in that data containing numerous names separated by a ";". I want to split those names to individual rows to a 2nd column. I found some code online which accomplishes the split portion. See below. What I would...

Hi all, I have got a macro that should select any cells within column C with a date value greater than the value I have entered into A1 I have ran the program and it doesn't cause any faults however It isn't selecting anything I'm sure my mistake is obvious any help would be appreciated the...