Search results

wow, this does work now that BrianWarnock's additions are included. What I needed it to do though (refer original post) is for the ws1 copying to commence from A6 rather than A1. Starting from A1 takes my headings and macro buttons with it. Is there a simple tweak that can be done to start it...

Got it working now. Me.Close also removed. Thanks

Did that but still won't work.

Unfortunately it doesn't seem to work. Any other ideas?

I need to copy cell contents from one worksheet to another but do not want empty cells included. The code needs to locate the first and last row and columns in sheet 1 that has the data, then copy paste-special it to another worksheet. I think it goes something like this (but I can't get it to...

Nope, can't get this one to work. Code crashes out at the first Me.Close. All I have changed are the paths. they now point to the respective files as follows: mypath = "c:\home\My Files\1111.xls" temppath = "c:\home\My Files\template.xls" Any ideas please.

Nope, can't get this one to work. Code crashes out at the first Me.Close. All I have changed are the paths. they now point to the respective files as follows: mypath = "c:\home\My Files\1111.xls" temppath = "c:\home\My Files\template.xls" Any ideas please.

DK's solution works. Thanks heaps T

I need some VBA code that will allow me to do the following 1. I run some code that is preset to open a workbook named “myworkbook.xls” 2. If it exists then it opens 3. However if it does not exist, then it presents a response box saying “myworkbook.xls does not exist. Create it now?" 4. If no...

excel...will be trying the other suggestions in due course Thanx

Does anyone kniow how to make the mouse cursor default to a specific field on a form when it opens so that you can start typing in it without having to click in it first

I need to open a workbook based on a text entry selected from a drop down box in another workbook. If a workbook by the selected name exists, then it opens. If it does not exist, I want the option to create it by first having the code open an existing template.xls file (on which the selected...

Thanks for this. Your test sheet works perfectly and is exactly what I want. When I transfer the userform to my workbook I have to also transfer your CRSUM worksheet to make the form work otherwise it errors out (see below). From that point on it all works fine until I update new data to the...

Attached. have gutted it a bit to reduce its size and removed links to external document but it still works.

Sorry but I simply cannot get the above code to work. I have tried two different ways. Firstly I tried through a UserForm (UserForm1). I added the suggested code to a Private Sub control routine as follows: Private Sub ComboBox1_Change() (code was added here) End Sub When I couldn’t get this...

got it sorted now, thanks for the help

Excellent, worked perfectly. Thanks heaps.

I have this Function that places the current date into a cell on a worksheet, from a NOW() entry on a FORM: Function FormatDate(X As String) As Variant Dim tempDate As Date If IsDate(X) Then tempDate = Format(X, "dd/mm/yy") FormatDate = tempDate Else...

When I use macro code to sort a list of row data that includes blank (empty) rows (because the rows with data will always vary) based on dates (dd/mm/yy in column B5) in Ascending order, 870 of the blank rows (of the 10000 allowed for) gets placed above my data rows (of which there are only...

Gidday, can you please tell me where I would place this code in the sub routine.