Pages

Monday, January 30, 2023

How to hide/unhide/delete all named ranges in Excel?

A. Xoa NamesRange

1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

Sub ShowNames()
'Update 20140318
Dim xName As Name
For Each xName In Application.ActiveWorkbook.Names
    xName.Visible = True
Next
End Sub

//

Monday, January 2, 2023

Ký hiệu cổng USB Type-C

Ký hiệu cổng USB Type-C