.cellsx

Is there a way to add only a range of cells instead of entire row? Here, I will like to insert from Col B to Col O. I have other data adjacent the range B:O and the entire row is interfering with the layout. I will be more than happy to find a work around. Thanks in advance...

I have worked pretty hard to come up with a solution that does what I had hoped but, it is SLOOOOOW!! Just under 28,000 rows of 8 columns took 19 minutes to process. Not acceptable! LOL! I am summarizing an application log. The process cycle creates three log lines per complete transaction. The...

I am using command button to add data, but i want that code should also have duplicate entries restriction included in it. Please check my code and help me finding the proper solution. Thanks q in advance. Dim x As Long Dim y As Worksheet Set y = Sheets("PRC Training Database") x =...

This code was provided to me by this forum and it works perfect. I want to expand it, but I have tried lots of different mods to it unsuccessfully. The goal is to allow any number of columns to be copied over to "Hstry" worksheet, based on the valve ("4"), column H on sheet "WO" What controls...

Hi I have the code Private Sub Worksheet_Change(ByVal Target As Range) Dim x As Long Dim LR As Long Dim C4 As Variant C4 = Worksheets("P").Cells(4, 3).Value Application.EnableEvents = False With Worksheets("S") LR = .Cells(.Rows.Count, 1).End(xlUp).Row For x = 1 To LR If...

Hello, Hope you are well. I have a loop that should place data from Sheet18 to Sheet11 from a Userform showing on Sheet1: If a Column 2 value on Sheet18 is equal to a textbox value similar to FDS002/18 AND a Column 6 value on Sheet18 is equal to a combobox value eg SF AND a Column 10 value...

Hi, I have the following code that imports picture from a directory based on cell value however if the file is not there it leaves a blank, what I've then conducted is to manual copy the image from google into a separate sheet and instead of returning blank I want it to look into that sheet to...