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!

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

Search results for query: *

  1. drgoatboy

    Traversing columns in excel

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

    Traversing columns in excel

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

    Traversing columns in excel

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

    Cell padding in a cross tab

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

Part and Inventory Search

Back
Top