Recent content by macajm

Thanks IRstuff - what you say works - strange, but true!

If I have deleted data or even deleted rows at the end of my spreadsheet, then when using the menu item "Edit|GoTo|Special|Lastcell the current cell becomes that maximum number of cells ever used, rather than the last non-blank cell. Does anyone know how to jump to the last cell containing data?

Ryan, Let us know how you get on with Microsoft, because I haven't solved it yet either. macajm

Open the Control Toolbox and select design mode then click properties. Then choose each radio button in turn and find the "GroupName" property which you should set to a different name for each group of buttons. eg if buttons 1 & 2 are to be grouped together, give them both the GroupName...

If you don't want the lines going to/from the zero points (or between non-sequential points where a zero has been eliminated in between by one of the other suggested methods), you can manually eliminate them by clicking on the line segment a second time (the first time selects the whole series...

If you select the whole spreadsheet and increase the row height to double the normal height, then select the columns for the average area, length and volume and format them for "top" alignment (the chainage and end areas being the default "bottom"alignment), this should...

You may be able to adapt the following macro which I use to do the opposite (ie to shade the cells containing a formula) You need to select the cells first that you want to check or else click in the top left corner to select all cells of the spreadsheet, then run the macro to set the format. [i...

try using the INDIRECT function.(see Excel Help)

I think you just need to put the sheet "B" reference in the formula like this:- =MID(CELL("filename",B!A1),FIND("]",CELL("filename",B!A1))+1,30)

Apologies - I shouldn't have rushed in - further correction of formula in C4, should be =if(and($A3>=$A$1,$A3<=$A$2),$B4,&quot;&quot;)

Apologies - correction of formula, should be =if(and($A3>=$A$1,$A3<=$A$2),$B3,&quot;&quot;)

Lets's assume your data is arranged as follows:- A3 : Heading &quot;Date&quot; B3 : Heading &quot;DataValue&quot; A4 to A999 or whatever : actual dates B4 to B999 or whatever : corresponding data values Then in cell A1 enter the earliest required date, and in cell A2 enter the last required...

Thanks ProjEngKLS - That's the trick I was looking for.

Does anyone know how to find dependent cells after using the &quot;Trace dependents&quot; button on the Auditing toolbar, when the dependent cells are in another worksheet? (It's fine if they are on the current worksheet, as Excel shows arrows, but if on another sheet, just an icon appears)

I thoroughly agree with ~dison Use &quot;Centre across selection&quot; wherever possible instead of merge cells. I even keep an &quot;UnMerge Cells&quot; button on my toolbar to use with imported spreadsheets. Does anyone know how i can get a &quot;Centre across selection&quot; button to add...