Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » New Worksheets

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

New Worksheets

Resolved · Low Priority · Version 2007

Reply Wed 1 Apr 2009, 15:59Delegate Soyful said...

Soyful has attended:
Excel VBA Intro Intermediate course

New Worksheets

When you have a number of worksheets in a workbook, can you hide the worksheets, (columns and rows) and then navigate between the worksheets? Do you have to do this in VBA or do you have to create hyperlinks in normal excel mode?

For upcoming training course dates see: Pricing & availability

Reply Thu 9 Apr 2009, 10:38Trainer Carlos said...

RE: New Worksheets

Hi Soyful

If you hide Columns or Rows on a Worksheet you can still reference the hidden data using VBA.

So if you have hidden column "D" in your worksheet you can refer to a cell in that column eg:

Msgbox Sheets("Accounts").Range("D3").Value

will display the value in that cell on a message box

Hope this helps

Carlos

Wed 15 Apr 2009: Automatically marked as resolved.

Excel articles

· Tell AutoFill What To Do And It Will Oblige
· Excel: Save Time With AutoFill
· Microsoft Excel 2007
· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· Making The Most Of Filtering In Excel

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips