-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
xl2007
-
S
Trouble interpreting date range. Excel2007
I am trying to build an Equipment Replacement Schedule for computer hardware. I have a column that reads the warranty start date and adds the number of years that has been determined as the replacement cycle. That looks like this...- sdandolini
- Thread
- dates xl2007
- Replies: 12
- Forum: Excel Questions
-
1
Get Excel 2007 to consider only filtered cells
Hi, I have put on a filter in my sheet and want to copy certain values from Column W to column X with the filter on. However, when I copy across the values with the filter still on it is ignoring the filter and just replacing the values sequentially. For example with the filter on I have rows...- 1021557
- Thread
- filtered data xl2007
- Replies: 5
- Forum: Excel Questions
-
where do I find the selector in XL2007?
Hi Where do I find the selector in XL2007 so that I don't have to manually select each shape? I want to grab an entire selection in one shot! I still hate this ribbon! :mad: Thanks Jon- Jon von der Heyden
- Thread
- xl2007
- Replies: 3
- Forum: Excel Questions
-
A
Conditional Formatting XL2007
Hi All XL2007 includes some supplied conditional formatting rules/formulas. Is there a way to "reveal" the actual formula code behind these supplied conditions, not just their "english" description? Regards AlMorl- AlMorl
- Thread
- conditional format conditional formatting xl2007
- Replies: 1
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
Increase the list fill range with vba
- Started by dpaton05
- Replies: 65
How do I increase the list fill range so that when I add items to my list, a combo box that has a list of the items in it is updated... -
Move or Copy sheet not working / Also VBA Run-time error ‘1004’: Copy method of Worksheet class failed
- Started by EC1728
- Replies: 29
Good morning everyone. I have recently run into the following problem: I have searched the forum along with numerous other sites and can't seem... -
How can I change my code so that it doesn't send out blank emails?
- Started by mrindira
- Replies: 26
Hi, So I am sending out emails using thunderbird.exe and I am trying to get the the email to copy and paste TPerf.Range("A1:H40") into the body... -
How to apply my VBA Code on multiple workbooks in a folder
- Started by Navi_G
- Replies: 24
Hi Experts, I am here to find a help. I have a VBA code for my reports i want to apply this code on multiple workbooks in a folder at once is that... -
Annoying Problem With VBA Editor Crashing Excel
- Started by Ark68
- Replies: 33
I am working on an Excel VBA project and have recently started encountering a very annoying problem. When I am testing my project, if I run into... -
Counting Formula
- Started by BrettOlbrys1
- Replies: 22
Based on a week date, I want to assign a "1" to that date. The dates greater than that date, I want the value to count up by +1 and the dates...
