Activecell offset what is

Check the existence of ActiveCell. Entering Text in the Current Cell. Entering a Formula in a Cell. Moving to Other Cells. Move to the new cell, you need to use the Activate or Select method. Get the address of ActiveCell. Select active cell and up to the end. Select ActiveCell and cells to its Right. Select ActiveCell and cells to its Left. Select ActiveCell's range.

SpecialCells xlLastCell. Offset to move the curren selection. If the value of the active cell is too big, change it. Repeating Actions with a Loop. Do-While loop with ActiveCell. Do-Until loop and IsEmpty. Uses the EntireColumn property, which returns a Range object that consists of a full column:. Select Current Region. Select Active Column. Log in. Install the app.

If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter clares Start date Oct 23, Joined Mar 14, Messages Hi All I am using the 'ActiveCell. Offset -1, 0. Select' to select and make the selected cell the active one. From this point I want to select a range which selects the next 6 columns.

There doesn't seem to be an active range command, if there were I could possible do: ActiveRange 0,6. Is there a way that I can select a range. Each range will be different! The example selects the table, without selecting the header row.

The active cell must be somewhere in the table before the example is run. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.

Privacy policy. Skip to main content.