Pages

Saturday, January 28, 2012

My Menu ver 1.0 - Select Range

3 Select Range


a) Select Range - If you want to select the range like "a1:d50" . Click on select range - it will show a message box and type a1:d5 ( Note do not use dollar signs or double quotes) simply type like a1:a10 or z1:ad50 ,etc. Snapshot below-



B) select Blank Cell- it will select the blank cells in the selected area. Snapshot below-



c) Select Used Range - It will select the used range in the active sheet.

d) Select Visible Cells - It will select all the visible cells in the selected area.

e) Select Cells with Formula - It will select all the cells with formula in the selected area or range

d) Select Constants - It Will select all cells with data in the selected area or range (Ignore all cells with formula and blank cells)

1 comment:

  1. Download Link http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html

    ReplyDelete