myrng

Hi I have quite a few repetitions of the scrip below with similar changing values. IS there a neater (For each) loop that i could simplify this code rather than just repeating it? Private Sub Worksheet_Activate() MyRng = 4 + Sheet12.Cells(3, 5) MyRng = "E5:" & "E" & MyRng...

I have a range of cells on Sheet1, (“C2:N35”), that have values/text in. Some cells are empty and I want to merge the blank cells to the cells above with values/text in the same column. I though that the following macro would work, macro is in Module1. When I run the macro I get the following...

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

I want to highlight the duplicate row & strike the contents. What to modify in the below code, to get the result Dim ma As Workbook Dim mas As Worksheet Sub test() Application.ScreenUpdating = False Application.DisplayAlerts = False 'Set Master File Set ma = ThisWorkbook Set mas =...