Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. macajm

    GoTo Last Cell

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

    GoTo Last Cell

    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?
  3. macajm

    Excell into word, clipping sheet

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

    Ungrouping radio buttons in Excel

    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...
  5. macajm

    Charts with zero values for data points

    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...
  6. macajm

    Drop Column

    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...
  7. macajm

    Highlighting data (as opposed to formulas)

    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...
  8. macajm

    EXCEL CELL REFERENCES

    try using the INDIRECT function.(see Excel Help)
  9. macajm

    different sheet name in cell

    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)
  10. macajm

    date list extraction

    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;)
  11. macajm

    date list extraction

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

    date list extraction

    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...
  13. macajm

    Tracking down dependent cells

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

    Tracking down dependent cells

    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)
  15. macajm

    SORTING a Worksheet With Merged Cells Not Same Size

    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...
  16. macajm

    Display spreadsheet cell data as footer for chart

    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(&quot;a1&quot;) End With End Sub To M.Smith - How do you create a...
  17. macajm

    Display spreadsheet cell data as footer for chart

    Does anyone know how to display info from a spreadsheet cell as part of a header or footer on a chart (or anywhere else an a chart for that matter)?
  18. macajm

    Blasting Causing Subsidence

    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.
  19. macajm

    Formula OR value in cell?

    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.
  20. macajm

    Formula OR value in cell?

    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 &quot;GET.CELL&quot; function nor to the particular variant of the &quot;INDIRECT&quot; function you use.

Part and Inventory Search

Back
Top