Need to Select Data Range in Excel In Microsoft Excel, several operations like delete, edit, type, and other formatting can be done only if we select the range of cells we need to change. There are several ways in which we select the range of
Used Area of an Excel Sheet There are many situations when we need to perform an action on all rows and columns with data in an Excel sheet. In order to do that, you need to know which row/column of data is the last. In
Rows are the horizontal layers of data — whether empty or not — in any table. You can think of a worksheet in MS Excel as a table. Likewise in Word, tables can be inserted and used. Rows are essential part in any table used
Why would you want to delete a row? Rows are the horizontal layers of data (that could also be blank) in any table. Worksheets in MS Excel are actually all considered to be tables. In MS Word, tables can be inserted into documents for your
Introduction Freezing panes is a very handy feature that is indispensable in any Excel workbook that has more than few columns or few rows. In this article, we will take a look at exactly how to utilize the Freeze Pane feature in both Excel and
When we use VBA to automate Excel operations on data or tables, one of the most common things we want to do is to find the number of rows of data or the number of records, in a worksheet. In this article, we’ll go through
In this article I will explain how you can add and delete rows and columns from tables in a word document using VBA. Every word document has a Tables collection The first step in working with a table in VBA for word is to determine the
Jump To: Apply Fill Pattern to Sheet Modify Sheet’s Fill Pattern Color – Apply Fill Pattern to Sheet: The following line of code applies the Reverse Diagonal Stripe fill pattern to sheet 1: Sheet1.Cells.Interior.Pattern = xlDown Before: After: – Modify Sheet’s Fill Pattern Color: The line below
Jump To: Apply Fill Pattern to Row Modify Row’s Fill Pattern Color – Apply Fill Pattern to Row: The following line of code applies the Reverse Diagonal Stripe fill pattern to row 3: Rows(2).Interior.Pattern = xlDown Note: The intellisense may not work while working with the Rows member.
In this article I will explain how you can use VBA for word to resize table columns and rows. Every word document has a Tables collection The first step in working with a table in VBA for word is to determine the table index. Tables in