cel

Hello, Is it possible, (how) to define the image on a cell value? - If on sheet 'worksheet 1' cel A1 the value = 1 -> put image1.jpg in the rightheader. - If on sheet 'worksheet 1' cel A1 the value = 2 -> put image2.jpg in the rightheader. Thanks a lot !

Good afternoon. I have a single Row A1:TT1 with data I have imported from an API output. The data looks similar to this and I import it using a comma delimiter [{"instructorEmail":"jby@xyz.com","instructorUserId":"123","timeZoneName":"(UTC+01:00) Brussels, Copenhagen, Madrid...

Want to copy range A1:I100 from sheet 1 workbook A to range starting cel B2 in sheet2 in workbook B

Hello,</SPAN></SPAN> The code below do highlight duplicates in various colours as shown below</SPAN></SPAN> Sub Find_Duplicate_Entry() Dim Cel As Variant Dim myrng As Range Dim clr As Long Set myrng = Range("D6:D" & Range("D65536").End(xlUp).Row) myrng.Interior.ColorIndex =...

Hello! The macro I have been using to auto lock cells after they have had anything written into them works great! However... Merged cells.... It can't handle merged cells. Any idea's on how to improve the code to make it also lock cells? This is the code I have been using Private Sub...

I do not how to write VBA codes, however this VBA formula I found on the internet allows me to lock cells after data entry as intended. It doesn't allow Filtering cells, cell highlighting or font modification for protected cells. Can someone help me modify this so it allows...

Hi All I have a sheet called all data and multiple other sheets for individuals. Based on a defined cell value the macro copies all rows from "All Data" that match the value of the individual. This works fine when there is a sheet for each unique individual but where there is data for someone...

Hi, How do i write a code to find multiple words (for example: AM and PM) in a column and assign a number "1" at the next 2 columns. I'm able to find "AM" and assign 1 next to it but i don't know how to add PM into the code and move the number "1" to the next column. I would be so grateful...

I am not sure what I am doing wrong here. It errors out when it reaches the worksheetfunction Sub STwoFill() Dim rng As Range: Set rng = Application.Range("STwo!C14:C1013") Dim cel As Range Dim NorMean As Integer Dim NorSD As Integer NorMean = Sheets("STwo").Range("C5").Value NorSD =...

Hi, this is my current code. Sub test() Dim col, ro, col2 As Double Dim sCellVal As String col = 0 col2 = 0 ro = 0 Dim cel As Range sCellVal = Range("C9").Value If sCellVal Like "Night" Then For Each cel In Worksheets("Service").Range("C41:NR41") If cel.Value = Range("B9").Value Then...

Hi I need to remove all the empty rows, I have written this code but it removes 1 row at a time. Sub RRow() lastrow = Cells(Rows.count, "A").End(xlUp).Row Dim rng As Range: Set rng = Application.Range("A1:A" & lastrow) Dim cel As Range For Each cel In rng.Cells If cel.Value = "" Then...

Hello, I am using a macro to find & replace, but it work only when the cell has the value itself. I need the replace when he value contains in the cell, e.g. My knowledge in vba is almost null, please help me 1a = X A1...

Hey Guys, Please check code below. This code will delete entire row if it find the given word. I want to change this code to give more words criteria instead of one word. So that i no need to repeat the code again and again to delete the rows. Thank you. Sub DelWords() Dim SrchRng As Range, Cel...

I've searched around and can't find anything exactly like what I'm experiencing. I just recently upgraded to Office 2016, but the problem happened on Office 2013 also. My workbook contains no more than 300 formulas. Half of them are pretty simple IF statements. The other half are AGGREGATE...

In part of some code I'm working on, I'm trying to find the cell containing the first day of the previous month, then hiding everything from column U up to that column. I've attempted a number of different methods, but nothing I've tried seems to work - it doesn't give an error, just skips...

Hi! So we recently switched form excel 2010 to 2016 (finally) and my macros are now working differently. I assume this may be a known issue, but I haven't been able to find the best info when searching online. So here is the specific issue: My macro is performing 3 actions I guess you could...

Hi All I'm currently using some VBA to hide rows based on value in a cell and what I would like to do is apply that code to a range of worksheets in the workbook, how would I go about this. Lets say the worksheet names are called Month1, Month2, Month3 etc through to Month12. This is my code...

Excel friends, I am using the code below to change some cells conditional formatting. Since VBA sets "cel.Address" as an absolute reference by default. How can "cel.Address" be modified to be applied as a Relative Reference? For Each cel In Rng.Cells With cel cel.Select...

Hi all, It is the very first time I work with VBA and I am struggling quite a bit. I have an Excel sheet in wich I have to insert a number of columns equal to a value in a cell. Note that the value in this cell will change over time. As a result, it is always the same cell that I would like to...