Search results for query: *

Yogi, thank you for your reply. I tried this method and it did not work, so I Googled for more answers. Found more information. http://msdn2.microsoft.com/en-us/library/bb209650.aspx You cannot "unapply" names; to delete names, use the Delete method. John Walkenbach's "Power Utility Pak v6"...

I have a complex formula, so I created cell labels to reference in my formulas. I think that this might confuse my co-workers and I would like to be able to convert back to A1 references. Seems like I have done this in the past and it was easy, but I can't seem to find this solution. Age or...

I had scheduled an important meeting and I wanted to copy and paste attendee tracking information into Excel to see the status of who had accepted, declined, or no response. I was very disappointed that Microsoft application help indicated that this could not be done...

I am having problems using vlookup and cell with named range to return value. If I manually put in the formula =VLOOKUP($B$4,'IFS Rates Sheets 6-01-05 2.xls'!National_Rate_Chart,VALUE($C$ 3+1)) the formula works. I would rather use =VLOOKUP($B$4,$C$2,VALUE($C$ 3+1)) with the cell C2 having the...

Brad, thank you for your reply. I used your formula and it did give me the correct count of the total unique names, but when I turned on autofilters and selected 1 name, the value still displayed the total unique numbers instead of 1. Only visible is one of the items that I am looking for...

I have a similar need for a formula that counts unique visible cells. The data range could be either text or values. Thanks HCLeslie

Thank you for posting this question. I am just starting to write a macro to use exactly the same logic of using autofilters to identify specific criteria in column and then to populate blank category column. Did you find answer or solve problem for the label and not matching criteria result...

Skip and Geoff, Thank you both for the information and the humor. Skip, I am not able to run you code, when I paste this into the VBE and try to run, it doesn't process or recognize this as a macro. I understand that I need to finish this up with the copy command, but I must be leaving out a...

The column heading will be in row 1. The data will start in row 2, but might be blank. The number of empty rows will vary. The data source was not originally a required field. Total rows should be less than 5,000. Thank you

What is the best way to select and copy a column of non-contiguous data without copying the first row that contains a column heading? Thanks

I have a string variable Manager_Val that I would like to use in autofilter criteria .Range("A1").AutoFilter Field:=2, Criteria1:="<>(Manager_Val)" When I run the macro I am getting the actual name “Manager_Val”, instead of the value of the variable. How do I refer to the variable Manager_Val...