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

macros

ResolvedVersion 2007

Helen has attended:
Excel Advanced course

Macros

When writing a macro, I have difficulty where end up with lots of decimnal places (i.e.

RE: Macros

Hi Helen

Could you send me a copy of the workbook where this problem is occuring so I can have a look at the code.

Send it to my attention to:

carlos@stl-training.co.uk


Regards

Carlos

RE: Macros

Hi Helen,

As this question has been left unanswered for over a month, the system will automatically mark this query as resolved in the next 5 days if we don't hear from you.

If you still require assistance with this query, please post a reply and we will assist you further.

Thank you.

Rich

Mon 24 Nov 2008: Automatically marked as resolved.

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

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.