Recent content by nashlow

Thanks Greg, Yuor advice was very helpful and intend to use it. My specific problem is to scan a row of columns looking for particular cities. If city fits the criteria, its column stay unhidden otherwise hide all. I am sure I can tune your idea to suit this criteria. I am also looking at the...

Hi, I need help in Excel vba to hide columns based on the text headings of individual columns. So if I only need to display cities on the East Coast and hide the rest from a spreadsheet of franchises US wide, how do I manage this? Appreciate all your assistance. Nashlow

Hi there, Sorry I did realise I missed putting enough info in my post. The spreadsheet is exported from Lotus database as an excel spreadsheet. Once in Excel, I applied a VBA code to hide the unwanted columns with this code: Range("A:A").Select Selection.EntireColumn.Hidden = True...

Hi there, Part of a bigger picture, is to hide a number of columns from an imported spreadsheet. Unfortunately, hiding the few nominated columns via CBA ends up hiding ALL the data columns on the spreadsheet. Does anyone know whats happening and/or how can I overcome this Excel problem...

Hi, I have developed like a seminar attendance feedback database with names of participats, dates, their comments etc so as to feed them on to forum presenters. However, I need to transfer some of the information from access to a word letter template and save the word documents in a folder...