Search results for query: *

Hi I've got real problems in word 2003 trying to get the document map to show the outlined number when I place a pagebreak just before the numbered line. If I place a page break at the end of the previous line i get a line return on the new page then the numbered heading, or if I insert the...

Hi I am copying a worksheet may time over into the same workbook. Once I reach 59 sheets (total) i get an error Run-time error '1004': Copy method of worksheet failed the line of code i am using is Worksheets("Boom").Copy After:=Worksheets(AfterSht) "boom" is the sheet i have already...

Hi All I don't know if its possible, but what I would like to do is take the inserted header picture and show it in a Image control on a form. don't really know where to start. Claude-Henri

Hi I'm tying to save a file which is opened from a template. When the SaveAs is executed (the last line) I get this error. I've got no idea? Run-Time Error '-2147417848 (80010108)': Automation Error The object invoked has disconnected from its clients. Sub SaveCrane() With SaveFile...

this is my code below the .select command selects the area i want to set as the print area, but the ".PrintArea =" still returns the ".UsedRange" range. Doesn't make sense to me. With Worksheets("Fly Chart") .UsedRange.Resize(.UsedRange.Rows.Count, _ .UsedRange.Columns.Count -...

Hi I'm trying to add a template to my workbook but I get this error Run time error '1004' Method 'Add' of object 'Sheets' failed my code is Worksheets.Add(After:="Geometry & Loads", Count:=x, _ Type:=xlWorksheet) = ThisWorkbook.Path & "\Wave.xlt" I also tried Worksheets.Add...

Hi my problem is that Temp is always empty,even though all the cells in RadiusRange have been filled with numbers or text i.e. "6". What is wrong with the code, I've been racking my brain to try figure it out but no luck. I just upgraded to Office 2003, and I am sure that the code below...

Hi All I would like to know if there is a way of manipulating the range returned by worksheet(x).usedrange or another way of deleting the whole area in one go(as its faster) instead of 1 row at a time what the problem is is that i print out which an unknown number of lines, so would like to...

Hi I was woundering about the letter "d" in a text box. I have a condition IsNumeric(textboxX)and for some reason "d" or "D" is treated as numeric "e" and "E" are as well but this is understandable (being for exponent). No other letters cause this. Does "d" have some significance I don't know...

hi I'm writing variables (defined as single) to excel spread sheets but for some reason the the actual value in the cell is a double. It doesn't seem to make much sense to me. I have been able to prevent this before but it was pretty cumbersome (i've forgotten exactly how at the moment), it...

I would like to be able to navigate around an excel workbook while running a macro I thought i could use a modeless form but when i press the control buttons on it the event subroutine doesnt start. when the form is shown the macro doesn't wait for it to close before proceeding. I need the...