Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba

ResolvedVersion 2003

Neil has attended:
Excel VBA Advanced course

VBA

Is there a function like UBound(), which returns the index number of the filled cell with the largest index number (instead of the index number of unfilled cells)?

RE: VBA

Hi Neil

Thank you for your question

First let me apologise for the delay in responding to your question. We have recently had very high volumes of posts on the site.

If your question is still current could you clarify a few points for me? What precisely do you mean by index number, are you refering to the index function? Could you also perhaps provide a concrete example to help me place the problem in context?

Thanks

Stephen

RE: VBA

Hi,

We are clearing some of the outstanding questions in the forum. As this post has been inactive for quite some time, the system will automatically set the post to 'resolved' in the next 5 days unless a follow-up post is made within that time.

You can always mark the question as 'unresolved' at any point if you require further assistance with this matter.

Regards,
Best STL Forum Team

Wed 24 Dec 2008: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.