Search results for query: *

Thanks Skip, I have thought about this a bit more and it makes sense. I was not certain about the cells() function but I have worked it out I think. I very handy tool that!! Thanks again

thanks for the quick response skip. Does that not then go down the page? (Or am I being Dim?) I was hoping to go across (horizontal) If I have got the wrong end of the stick any chance you could include all the code... Or is that just being cheeky...

hi all, I'm sure this is really easy but I am not a VBA expert. Basically what I want to do is starting from a set cell I want to move the next column and colour that cell. And do this under condition in a for loop. (what I am trying to do is make a Gantt chart) I know how to set the colour in...

This is probably really simple... I have made a cross tab and it is just what I needed. However in each cell of the table there seems to be loads of padding around the text. i.e. the lines around each cell are not very close to the text itself and I cannot reduce the text box anymore without...