Friday, 9 July 2021
Dairy Milk Lady Dancing Ad | Cadbury Dairy Milk Lady dancing Old Ad | Cadbury's DAIRY MILK Old Ad
Watch Dairy Milk Lady Dancing Ad | Cadbury Dairy Milk Lady dancing Old Ad | Cadbury's DAIRYMILK Old Ad. Cadbury Dairy Milk Old Cricket and Lady Dancing Ad.
Old Doordarshan Ads. Doordarshan 1990's Ads. Doordarshan Classic Ads https://www.youtube.com/watch?v=e6Izf...
Sachin Old Ads. sachin Tendulkar Old 1990's Ads. Old cricketers Ads https://www.youtube.com/watch?v=12jD1...
Helly & Chilly Mahabubnagar. Helly and Chilly cafe Mahabubnagar. Helly & Chilly Cafe Mahabubnagar. Helly & Chilly Cafe. World's Longest French Fries. World Record French Fries. Helly and Chilly Mahabubnagar
#Helly & Chilly Cafe | Longest FRENCH FRIES World record
Macro to find Unique Values in excel | VBA Code to highlight unique values in excel
Macro to find Unique Values in excel | VBA Code to highlight unique values in excel
1. Open active excel sheet
2. Press Alt + F11 and Visual Basic Application window will open.
3. Go to Insert Menu and select new Module.
4. In new Module insert the below VBA Code and save it.
5. Before do the above process, excel sheet must save as Macro-Enabled.
6. To do Macro Enabled, open Excel Sheet and Click on the Office Button which is at left top corner on excel sheet.
7. Select Save as and again select Macro Enabled Worksheet and then save it.
Sub highlightUniqueValues()Dim rng As RangeSet rng = Selectionrng.FormatConditions.DeleteDim uv As UniqueValuesSet uv = rng.FormatConditions.AddUniqueValuesuv.DupeUnique = xlUniqueuv.Interior.Color = vbGreenEnd Sub
VBA Code to hide rows with number zeros in Excel | Macro to hide rows with number zeros in Excel
VBA Code to hide rows with number zeros in Excel | Macro to hide rows with number zeros in Excel
1. Open active excel sheet
2. Press Alt + F11 and Visual Basic Application window will open.
3. Go to Insert Menu and select new Module.
4. In new Module insert the below VBA Code and save it.
5. Before do the above process, excel sheet must save as Macro-Enabled.
6. To do Macro Enabled, open Excel Sheet and Click on the Office Button which is at left top corner on excel sheet.
7. Select Save as and again select Macro Enabled Worksheet and then save it.
VBA Code to Hide Rows With Zeros
Sub HideRows()
Dim cell As Range
For Each cell In Range("J19:J33")
If Not isEmpty(cell) Then
If cell.Value = 0 Then
cell.EntireRow.Hidden = True
End If
End If
Next
End Sub
Dim cell As Range
Macro to Delete Hidden Rows on Filtered Cells | VBA code to Delete Hidden Rows on Filtered Cells in Excel
Macro to Delete Hidden Rows on Filtered Cells | VBA code to Delete Hidden Rows on Filtered Cells in Excel
1. Open active excel sheet
2. Press Alt + F11 and Visual Basic Application window will open.
3. Go to Insert Menu and select new Module
.4. In new Module insert the below VBA Code and save it.
5. Before do the above process, excel sheet must save as Macro-Enabled.
6. To do Macro Enabled, open Excel Sheet and Click on the Office Button which is at left top corner on excel sheet.
7. Select Save as and again select Macro Enabled Worksheet and then save it.
VBA Code:
Sub DeleteBlankRows()
Dim x As Long
With ActiveSheet
For x = .Cells.SpecialCells(xlCellTypeLastCell).Row _
To 1 Step -1
If WorksheetFunction.CountA(.Rows(x)) = 0 Then
ActiveSheet.Rows(x).Delete
End If
Next
End With
End Sub
Animals 8K Ultra HD Videos - 8K Ultra HD Videos - Beautiful 8K Ultra HD Videos of Animals 2021
Animals 8K Ultra HD Videos - 8K Ultra HD Videos - Beautiful 8K Ultra HD Videos of Animals 2021
Monkey Funny Expression Seeing The Toy Tiger | Funny Monkey Expression 2021 | Monkey Comedy Videos 2021
Monkey Funny Expression Seeing The Toy Tiger | Funny Monkey Expression 2021 | Monkey Comedy Videos 2021
Subscribe to:
Posts (Atom)
-
Monkey Funny Expression Seeing The Toy Tiger | Funny Monkey Expression 2021 | Monkey Comedy Videos 2021
-
Macro to Delete Hidden Rows on Filtered Cells | VBA code to Delete Hidden Rows on Filtered Cells in Excel 1. Open active excel ...
-
Macro to find Unique Values in excel | VBA Code to highlight unique values in excel 1. Open active excel sheet 2. Press Alt + F11 an...