Recent content by Dsuperc

Try Ctrl+` (That is the key above Tab or at the left of 1)

I have set up a switchboard, however whenever some one opens the file, the switchboard prints. How can I stop this?

sorry here is the link http://www.asap-utilities.com/

Why try to re-invent the wheel, down load this add in ( its free)with over 300 tools, one of them is "Delete leading and trailing spaces

Download this utility, its free http://www.asap-utilities.com/ There is a function, Text, remove all leading and trailing spaces, also, remove ending carrage return, and much more

Sub FanOut() Dim ColHead As String Dim ColHeadCell As Range Dim iCol As Integer Dim iRow As Long Dim lRow As Integer Dim NewWB() As Workbook Dim Fsheet As Worksheet Dim Answer As Variant Dim i...

try this site http://www.geocities.com/jonpeltier/Excel/Charts/DummySeries.html#Speedo

Had the same problem with a shared file. I changed the filter options on different columns until I could view the entire sheet. Realized then, some one formatted an entire column (rows 1 to 65536 )in a specific way.

Is it possible to do a mail merge in an Outlok Template? I have the data on a spreadsheet and I need to email the data from the last row of the spreadsheet to a fixed email address.

Ok, I had the same problem, and did a work around. Have the info on a table in MS ACCESS. Paste the Tax forms (PDF) as the background in a report. Import the info from the table ot better still from a Query. Place the data in the corresponding boxes on the PDF. This way you can print an...

Download this tool http://www.asap-utilities.com/ Its frss and got lots of tools, includung what you are looking for

there is an excellent example here http://www.xl-logic.com/

This would import a large tex file into excel Sub LargeFileImport() Dim ResultStr As String Dim FileName As String Dim FileNum As Integer Dim Counter As Double FileName = InputBox("Please enter the Text File's name, e.g. S:\Revenue\Straus\BATCHOCCMUM121002.txt") If FileName = "" Then End...

Try changing the printer from the "PRINT" option

Go to View, then create a SLIDE MASTER, insert this master slide whereever and whenever you want. It will contain the Colour, layout et.