This provides rather more flexibility because it will always refer to the range from the active cell to the cell 10 rows below it. Range(ActiveCell, ActiveCell.Offset(10, 0)) Several (non contiguous) ranges can be referred to by typing them into the Range argument with commas separating them and quote marks (вЂњ) at the beginning and end, eg.ДЄnother way of using referring to a range is from a currently selected cell to another fixed point in a worksheet, eg. refers to the range A1 : A10 and gives the same result as using Range(вЂњA1:A10вЂќ).

The first and most commonly seen after recording a macro is using the Range property:-ДЄn alternative way of selecting a range of cells that can provide more flexibility, is to separate the first cell from the last one with a comma, eg. Procedures will almost certainly need to work with ranges these ranges will usually differ in size and position in a workbook and hence, there needs to be flexible ways of identifying and selecting them.ДЄs a result, there are many ways of referring to a range. Manipulate ranges with the Offset and Resize functions Put right any errors and then save and close the file.The font in cell B4 should be made red and the font in cell C4 bold. Assign a keystroke of your choice to this macro and run it to check that it works correctly.In the same module sheet there is already a procedure named TestProfit that tests cell B4 and makes the font bold if its value is 15000 or over, and formats it red if below 15000.Д®dit the procedure with a loop so that after it tests cell B4, it also tests cell C4.Enter the following data into the newly created table.Use this button to run the macro and check that it runs correctly.Create a button on Sheet1 of the workbook and assign the CreateTable macro to it.formats cells A4 to C4 with a grey fill (Tip: ColorIndex = 15).

formats cells A2 to A4 with an italic font.

formats cells B1 to C2 with a bold font.

Launch the VBA Editor and open the module sheet in the Daily Profit and Loss project.

Excel vba tutorial advanced