Recent content by Rabbitoh
-
R
Copy only non-blank cell contents to another worksheet
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... -
R
Prompt to create and save a file mid-routine
Got it working now. Me.Close also removed. Thanks -
R
Prompt to create and save a file mid-routine
Did that but still won't work. -
R
Copy only non-blank cell contents to another worksheet
Unfortunately it doesn't seem to work. Any other ideas? -
R
Copy only non-blank cell contents to another worksheet
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... -
R
Prompt to create and save a file mid-routine
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. -
R
Prompt to create and save a file mid-routine
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. -
R
Making the cursor default to a form field
DK's solution works. Thanks heaps T -
R
Prompt to create and save a file mid-routine
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... -
R
Making the cursor default to a form field
excel...will be trying the other suggestions in due course Thanx -
R
Making the cursor default to a form field
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 -
R
Open a workbook from a drop down box entry selection
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... -
R
Selecting filtered dates from a VBA FORM to run in an AutoFilter macro
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... -
R
Selecting filtered dates from a VBA FORM to run in an AutoFilter macro
Attached. have gutted it a bit to reduce its size and removed links to external document but it still works. -
R
Selecting filtered dates from a VBA FORM to run in an AutoFilter macro
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...