Show the current environment in Excel
It is important to know the Excel environment before starting a VBA macro. It is important for a VBA macro to set macro variables with key indicators to define the current environment to enable restoring the current environment before completion. Since many Excel VBA operations are executed on the current/active environment, changing the environment to execute can be necessary. Restoring the original environment in a necessary function of a VBA macro. In addition the time to manually restore the environment there is a possiblity that full restoration will not occur.
SAS Fifth Dimension Macro-Current environment
The current directory, active workbook name, active worksheet name, current row number, and current column number are some of the basic elements. The number of opened workbooks and their names, the number of sheets in each workbook and their names, the number of shapes and their types, the number of hyperlinks and their locations are a few more.
Knowing the format of a cell can be critical during assignment. Comparing two cells can be affected by the format of the cells. So being able to check the format of a cell is necessary.
Review the following code, copy it to Excel and execute it.
SUB INIT CURRENT_DIRECTOR=CurDir() BOOK_NAME = ActiveWorkbook.Name SHEET_COUNT = Worksheets.Count SHEET_NAME = ActiveSheet.Name CURROW = ActiveCell.Row CURCOL = ActiveCell.Column
CELL_TYPE_NAME = TypeName(CELL) CELL_FONT_NAME = ActiveCell.Font.Name CELL_FONT_SIZE = ActiveCell.Font.Size CELL_HIGHT = ActiveCell.RowHeight CELL_WIDTH = ActiveCell.ColumnWidth CELL_FORMAT = ActiveCell.Cells.NumberFormat CELL_ADDRESS = ActiveCell.Address END SUB