-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
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
- 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
- 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
- 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
- Replies: 1
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...