Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

	98.1 % recommend us
	More live stats...

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

Training information:

Macros

Resolved · Low Priority · Version 2007

Reply Wed 15 Oct 2008, 16:08Delegate Helen said...

Helen has attended:
Excel Advanced course

Macros

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

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Oct 2008, 13:29Trainer Carlos said...

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

Regards

Carlos

Reply Tue 18 Nov 2008, 10:46Trainer Rich said...

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 articles

· Automatically Insert The Time, Date Or Both In Excel
· Correct In, Garbage Out
· What Are Sparklines In Excel 2010?
· Creating Charts with Excel
· Using Excel For Simple Home Accounting And Budgets

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

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips