Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » vba courses london - Excel vba

vba courses london - Excel vba

ResolvedVersion Standard

Fri 4 May 2007, 13:48 Delegate Gunaratnam said...

Gunaratnam has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course

Excel vba

how to write code for " find a next available empty cell in the colum/worksheet"

Fri 4 May 2007, 14:36 Trainer Garry said...

RE: excel vba

Range("A1").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

vba courses london - Excel vba

Excel vba

RE: excel vba

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010