Search results for query: *

Skip I was using .Select to bring forward and send back certain shapes. Based on your comments i've moved away from .Select and am now using .Visible instead which actually workes much better for me. Thanks Owen

It looks like with excel 2007 you cannot select a form control and a shape at the same time. Trying to select a form control while a shape is selected deselects the shape in in order to select the form control - strange! To get around this I've split my code into two separate lines, one...

I have a macro that selects a number of shapes including text boxes, rectangles, spinners and group boxes. It works perfectly in excel 2003 but not in excel 2007. Using 2007 I get "run time error 1004, Application defined or object defined error". It looks like whenever I try to select the...

Cheers Hugh!

I figured it out based on your post. Thank you! Private Sub cbo0DCF1Priority_gotfocus() Dim i As Long Dim priority(1 To 28) As Integer, j As Integer Me.cbo0DCF1Priority.List = _ Worksheets("ProductSelection").Range("Priority").Value For j = 1 To 28 priority(j) =...

Thanks Hugh. That's great start. I'll re-post in the correct thread if I can't figure out the rest. Owen

Hi all I have a priority list of 1 to 28 which the user can select against any given product. As there are a number of products, there needs to be different priorities assigned and actions completed as a result etc. I have created a combo box to do this for me. The combobox list is a range of...

Thanks Gavin. Your first suggestion works perfectly. I found that my "non blank" blank cell originated from a formula I had that returned a blank "" into the cell if other conditions were not met. I then performed a paste special, pasting values only. I didn't know that the paste special would...

I think now there is a problem or excel program error with the list of data I have. When I run the code above it stops on A20 even though it appears blank. When I select cell A1 and then press Ctrl and Down Arrow cell A20 is selected telling me that excel thinks there is somthing in the cell...

Hi all I have a module that searches column A for non blank cells and deletes the non blanks (it needs to do this one by one as it's part of a larger routine, selecting the entire column and deleting isn't an option). The code is as follows: Sub FindAndeDeleteNonBlanks() ' Find the first...

Thanks Skip.. I can see now how it works. Problem is that my code is set up to loop through row 3 ("lRow1") to 1700 ("lRow2"). When I use specialcells it still looks for row 3 and when it's not visible gives the error - "no cells were found". I've pasted the full code in below so yu'll see...

Hi all I have the following code which searches through each row in turn looking for the first occurence of a comma. It then enters the cell location of this comma in a cell on the same row. I have approx 1700 rows to search which is taking a long time. But if I filter by only the required...

Yep - I figured it out after reading PHV's reply. Thanks guys. Owen

Hi all, I am getting error code "unable to get the find property of the range class" while executing the set statement in the following code. I can't see what the problem is with the code. Does anyone have any ideas? Range("IV" & lRow1).Select With ActiveSheet Do With...

Thanks for the reply John. I suspected also that I may have had extra "hidden" data in these extra fields and selected all fields after the row in question and deleted them. This did not fix the problem. I've experimented with deleting all other entries on the sheet except for the text I need...

Brilliant - thanks guys

Hi all, For a specific task I am reading the column number of a value in my sheet as being in column 57 which is column name "BE". I need to use the column name in a spreadsheet to locate a formula I have, but I do not know how to turn the 57 into BE. Can anyone help? Thaks Owen

Hi I have a dynamic named range as follows: = OFFSET('Summary Data'!$Z$2,0,0,COUNTA('Summary Data'!$Z$2:$Z$2),COUNTA('Summary Data'!$2:$2)) The code picks up creats the range from Z2 as required, counts along row 2 as required, but instead of stopping at my last value, keeps counting 20...

Yes. I've found several things..... There's an application called AutoFormat XL for Pivot Tables that will save your modified pivot table as a template which you can then apply to other tables. It's a good program (you can download a trial version). Problem with this is that if the users change...

Hi all Does anyone know of any articles or websites I can look up to get a good understanding on how to create my own pivot table report style? i.e. Instead of selcting one of the 15 or so styles offered by Excel, I'd like to create my own and be able to apply it as required. Thanks Owen