VBA WORD BUILD RANGE BY PARAGRAPH FULL

VBA WORD BUILD RANGE BY PARAGRAPH FULL

Selecting Full Table with Range with End Property – Example #6Īssume you have a data as shown in the below image. Similarly, if you want to select the last column need to use the xlRight method instead of the xlDown method. Selecting Range with End Property – Example #5 It will take you to the last un-break cell in the selected column. Similarly, in VBA, the same logic will be applied, but you should use the END property instead of the regular excel Ctrl button. If you want to select the last used cell in the column, how do you select it in excel? Usually, you first select the cell A1, and you will hold the Ctrl key and press the down arrow key & it will select the last used cell. Selecting Range with End Property – Example #4Īssume you have data as shown in the below image. Workbooks('Example WB.xlsm').Worksheets('Sheet1').Activate Selecting Range – Example #3įor example, if I want to select the range of cells from A1 to A13 in the workbook called “Example WB,” firstly, I need to specify the workbook name by using the Workbooks property, and I need to mention the full workbook name with its extension.Īfter selecting the Workbook, we need to select the worksheet using the Worksheet property. Similarly, if you select the range from different workbooks, you also need to specify the workbook name. This would also perform the same task as the previous one. Run this code using the F5 key or manually to see the result. As I have shown in the previous example, we can select the range of cells from A1 to A13 using the below method. You can supply the range in the first argument itself, or else you can supply it as two arguments as well. Irrespective of which sheet you are it will activate the Sheet 1 and select the range A1 to A13. If you want to select the cells in Sheet 1 only, then you need to supply this in code, as I have shown below.įirst, you need to activate the Worksheet name called “Sheet 1”, and then you need to select a range from A1 to A13.

Vba word build range by paragraph