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?
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...
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)
Lets's assume your data is arranged as follows:-
A3 : Heading "Date"
B3 : Heading "DataValue"
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...
Does anyone know how to find dependent cells after using the "Trace dependents" 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 "Centre across selection" wherever possible instead of merge cells. I even keep an "UnMerge Cells" button on my toolbar to use with imported spreadsheets.
Does anyone know how i can get a "Centre across selection" button to add...
TO jproj -
Thanks for your idea which I implemented as follows:-
Sub SSdata_toChart()
' Macro recorded 29/04/2002
' Puts contents of Cell A1 into Footer
With ActiveChart.PageSetup
.LeftFooter = Range("a1")
End With
End Sub
To M.Smith -
How do you create a...
We have been blasting approx 200m above current u/g coal mine workings with typical shots being 10tonnes explosive & max instantaneous charge per delay of 150kg. - no ill effects underground.
To: yakpol
Thanks - your solution works fine too. I shied away from using it at first (scared of the VBA word!), but I can see now that by having it as a Public Function in my Personal.xls , that I can use it on any spreadsheet without having to enter lengthy formulae in the conditional formatting.
to: a3a
Thanks - your solution works fine & I will use it.
However I don't understand how it works, because there is no reference in Excel help index (Excel 97)to the "GET.CELL" function nor to the particular variant of the "INDIRECT" function you use.
