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