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)
Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...
Please make sure that you have the latest Version Tool Last Updated on 17 Feb, 2012 Version 1.6 English Version For Excel 2007 &...
Adding Marquee in Excel worksheet Step 1 Step 2 Example 1 Continuous scrolling Add below code module1 or any new module Sub r...