Search results for query: *

I'm glad to know about the 7 levels of nesting functions...I hadn't realized that before. It looks like that's exactly what the problem was. Here's the function I was using to get the last for characters of the sheet name: (it is in K6)...

Lately I've been running in to a problem where seperate parts of a formula work but when I try to put them together I get error messages...WHY!!! -Clay claysdays.blogspot.com

I know this isn't a big deal and I know I can always use Alt+T and then O, but I was wondering if there was any other shortcuts for this...if not...is there a keyboard shortcut for viewing page breaks? -Clay claysdays.blogspot.com

OK...I think I'll follow you're advice and just redesign the workbook...I should have done that in the first place, Its definitely put together for input, not output. I just thought I might be able to work around the problem but, now I realize thats not going to happen. I've posted on...

Well I'm working on implementing the table but the problem is that each tab is actually a week worth of information, so every week the workbook will be one more sheet long. If I were the primary user of this book I would be able to add a new row everytime I add a sheet, but ideally I wanted to...

ok...I'll try the table. Any ideas why the format I was using for the Sum function worked when the sheets are typed in but why it doesn't work when they are referenced using 'indirect' or 'address'? Is it just a quirky thing or is there some kind of rule about that? -Clay claysdays.blogspot.com

If you try it though, my way works. As long as the sheets are consecutive, its a good work around so that you don't have to write out every sheet in your function. I just don't understand why it won't work with the Indirect function. -Clay claysdays.blogspot.com

First off, cell B1 contains the name of a sheet (sheet1) and cell B2 contains the name of another sheet (sheet7). I want to get the average of cell B6 from sheets 1-7. I can accomplish this by using the following formula: =SUM('sheet1:sheet7'!B6) however it may not always be sheets1-7...

I would like to lookup something in the right most column and return the contents of a cell to the left of it. I figure that I could do an offset to go to the left, but I don't know how to lookup sometihng and just return the cell reference (to plug into the offset formula) Maybe I'm going...

Last Friday at 4:30 I encountered this exact problem (not a good way to start the weekend). I posted on another forum and and someone referred me to this thread. I copied the code that Rob listed, changed the file name and set up the reference for Excel 9.0 objects. When I tried to run it, it...

I know this is going to sound silly but something similar just happened to a co-worker. He hit the 'equals' button on the formula bar and that help window dropped down, he hit OK and for some reason it worked, it must have been some kind of glitch. Its worth a try. If all your formulas are...

I have (or had) a workbood with loads of code that I've been working on for the last 2 weeks. I have a back up of it as of 3 days ago, but I've done alot today and yesterday. I think that I copied some code and pasted it at the bottom of a macro...it was supposed to be temporary, but I...

AWESOME!!! I didn't realize that I was supposed to put & "*" at the end. I was trying this: Selection.AutoFilter Field:=6, Criteria1:="=* & Sheets("All Days").[h5].Value *", Operator:=xlAnd and of course it wasn't working. Thank you very much again for this information. Now I have a start on...

I tried that and it seems to me that that Criteria1:="=**" would give me the "contains" search so I modified my code accordingly Private Sub CommandButton1_Click() Selection.Copy Selection.AutoFilter Field:=6, Criteria1:="=**" & Sheets("All Days").[h5].Value, Operator:=xlAnd End Sub...

How can I make sure that when the auto filter is applied it is using the "contains" option...it seems to be using "ends with" or "equals" -Clay claysdays.blogspot.com

Thanks, I'll try that, it would be nice to make this sheet as automated as possible. -Clay claysdays.blogspot.com

I'm not really sure what I did wrong, but it says that there is a compile error, syntax error. Here's what it looked like when I adjusted it for my sheet. I substituted what I thought was the correct reference but it must not be right. Sub LocationAutoFilter() Selection.Copy...

That did it, its amazing what a difference one little letter can make :)...thank you very much. -Clay claysdays.blogspot.com

I'm not really sure what I did wrong, but it says that there is a compile error, syntax error. Here's what it looked like when I adjusted it for my sheet. I substituted what I thought was the correct reference but it must not be right. Sub LocationAutoFilter() Selection.Copy...

I'm not new to Excel but just starting to learn about VBA. I tried recording a macro but it isn't working and I don't know enough about the expressions to correct it. I need to copy the contents of a cell and paste them into the custom search of the autofilter as a "contains" search. Here is...