Search results for query: *

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

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

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

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.

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.

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.

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