You are here:

Excel/Expert Profile

Aidan Heritage

Available

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards

Experience in the area

My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials

I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Ali	02/11/12	10	10	10	i am really thankful to you from .....
Kevan	02/10/12	10	10	10	It worked!!!! Thanks again!!!
Kevan	02/08/12	10	10	10
Kevan	02/07/12	10	10	10	Excellent as usual!
Parantapkumar	02/04/12	10	10	10	Thanks So Much. Actually I didn't notice .....

Recent Answers from Aidan Heritage

2012-02-10 Major VBA/Macro Lag!:

The first thing I would do in this case is to get the macro to set the calculation mode of the sheet to manual, and have it calculate ONLY the cells it needs to (or the workbook as and when it needs to)

2012-02-08 Excel - Hide #N/A:

I can think of a couple of ways - one is to use conditional formatting to simply hide cells in the event of an error, but as that would use the iserror worksheet function, it would be easier to use that

2012-02-07 Index formula using cell value for sheet reference:

Sorry, mistyped the brackets - I've done it in excel rather than trying to type it this time - try =INDEX(indirect(A1( cursor &"!R$1:R$20"),MATCH(1,(indirect(A1& "!A$1:A20")=$E13)*(indirect(A1& "!L$1:L20")=$R13)

2012-02-06 counting colored cells in a spreadsheet:

my email is aidan.heritage@virgin.net - just in case that helps (a means of getting a file to me for instance!). Insert the code I've given into a module, then enter the formula - but you would do

2012-02-03 % sign appears spontaneously:

I think you MAY have used the keyboard shortcut to set % formatting (see http://spreadsheets.about.com/od/tipsandfaqs/qt/81116percent.htm) - however, not a major problem - select the cells you want to

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Encyclopedia

Browse Answers: