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 TugboatEng 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: *

  • Users: Buffo
  • Order by date
  1. Buffo

    Decimal Point Alignment

    This solution works on the windows version http://www.cof.orst.edu/net/software/excel/tips/
  2. Buffo

    Getting rid of a link

    I use an addin from Microsoft's Help and Support. This searches all the appropriate areas. Up to now it hasn't failed me yet. Delete Links Wizard http://support.microsoft.com/kb/q188449/ Regards Ste
  3. Buffo

    How to pass the range as a variable to a chart macro?

    Can I Suggest you look at some of the chart examples on Stephen Bullens Excel Page. He has some examples using the Offset function as part of the series address. This may negate the need to use a macro at all. http://www.bmsltd.co.uk/Excel/Default.htm
  4. Buffo

    Thinner cell borders in excel?

    Thanks for the reply jproj, however the thinnest solid line appears to be 3/4 pt thickness. I need to use a finer solid line of 1/4 pt thickness. This can be done on say a word table but seems to be fixed in excel.
  5. Buffo

    Thinner cell borders in excel?

    Does anyone know if I can adjust the line thickness of a cell border around a table? This can be done in word and with drawn objects but in cell borders I can only see line styles.
  6. Buffo

    How to copy a formula without changing references

    Another alternative I have used in the past is to 1. copy the original sheet 2. drag the formula cell to the new position, on the copy, that you require. 3. copy the formula back to the original sheet 4. delete the copy.
  7. Buffo

    Data to Sequential Cells

    I hope I'm on the right track here, this is a simple loop to find the next empty cell in a row or column. Assumming the data is in column B (2 in macro) and the data will be in rows 10 to 110. For x = 10 to 110 If IsEmpty(Cells(x,2))then goto exit1 next x exit1: you can then use...

Part and Inventory Search

Back
Top