| Thread | Last Post | Replies |
|
| Variable Help | 22 Dec 2007 23:46 GMT | 3 |
I'm sure this is an easy task for the experts around here, but I'm having some troubles strating out. Basically I would like to be able to bring a gross margin value from our "Costing" and then recall that value onto a "Change Order Sheet". That much is simple enough, but next I ...
|
| create macro "merge selected cells"? | 22 Dec 2007 22:57 GMT | 7 |
I want to create macros that relate to selected cells, not absolute or relative references; specifically, merge and unmerge selected cells. Excel in Office 2003, Win XP.
|
| How to iterate through columns? | 22 Dec 2007 22:18 GMT | 1 |
I have a particular issue with columns. I have 4 columns. I need to iterate through the 4 columns (say H - K). The values in the columns are put there from a database record set. The record set, therefore, has a row length that could be variable,
|
| expanding numbers? | 22 Dec 2007 21:51 GMT | 7 |
I'm not sure how to title this post. But this is what i want to do. I need to take two variable numbers say 75 and 30000. Then I need to step out the difference over a variable amount of cells. in this case say 20 cells.
|
| VBA to select the cells next to the result of a find & combine the | 22 Dec 2007 20:39 GMT | 4 |
I've got data that always appears in the two cell immediately to the right of a cell that contains "Case:" that I'd like to select. In other words if "Case:" appears in C33, then the two cells I want to select are in D33 and E33. The trouble is the row isn't always the same ...
|
| rotate highlighting colors macro | 22 Dec 2007 19:11 GMT | 2 |
I need to create a macro that when pressed will cycle through a number of highlighting colors. So for example when I press the shortcut the first time it will change to yellow, a second time change to red, a third time to grey etc. etc.
|
| Open with Openform; Workbook not visible | 22 Dec 2007 18:20 GMT | 1 |
Is there a way to open an Excel workbook only showing a Openform (not showing the workbook at all)? I would like it to start with a openform asking a question; upon the response, it will open the workbook.
|
| Worksheet_BeforeClose conditional Worksheet change | 22 Dec 2007 18:20 GMT | 3 |
Trying to make the following macro dependant on any change in the active worksheet. In other words it should not be inaugerated if the the file just is opened for view or printing, but only when any cell in the sheet is changed. Can worksheet change be used? Does anybody have a ...
|
| sort issue: Excel seems to be treating my column of numbers "alphabetically" | 22 Dec 2007 15:01 GMT | 4 |
I am trying to sort a column of numbers in numerical order. When I attempt to do this excel seems to want to sort them as though they were letters. Here is an example: 1
|
| deleting multiple rows | 22 Dec 2007 14:53 GMT | 3 |
I need to delete subsequent rows, but i have to address the starting and the end points by referring two cells. I mean i dont want to use this: Rows("2:5").Delete
|
| date confusion | 22 Dec 2007 14:43 GMT | 3 |
general question here guys, I get a report that is in CSV form on a weekly basis that inludes dates. Some of the data has the date format reversed. i.e. 02/01 instead of 01/02. I am ok with the logic of sorting this issue BUT, sometimes the data
|
| Change name of pictures in worksheet | 22 Dec 2007 14:35 GMT | 1 |
I'm making a NFL playoff bracket - So I've copy and pasted the helmets of the teams over drop downs and am using ActiveSheet.Shapes("Picture 47").Visible = True then ActiveSheet.Shapes("Picture 48").Visible = False to show the correct helmet.
|
| Custom List | 22 Dec 2007 13:40 GMT | 1 |
Thanks for any help. This is on Custom List which I know how to create, my question is, Is there a way to name a custom list? What I want to do is create a time schedule starting at 7:00 and go from there every 15 minuntes till
|
| Chart label questions | 22 Dec 2007 10:50 GMT | 1 |
I have three questions about chart labels. I have labels on a bar chart. I have it programmed where the cell value in D5 is inputted into the label. First question. On my chart the on primary y axis is 0 and the scale is -.4 to .4, so 0 is in the middle of the chart. (this
|
| getting the active chart/chartobject's name | 22 Dec 2007 10:13 GMT | 4 |
Given the code below, does anyone have any suggestions on how to obtain the active chart/chartobject's name so that I can address Shape(name) properly when I try ot move the shape? [code]
|