| Thread | Last Post | Replies |
|
| move to the cell on the right, my code not working pls help | 17 Apr 2007 03:48 GMT | 5 |
Pls assist me. Thank you. My macro will move to the cell on the right when the current cell is occupied & stop once it has been set to the new empty cell. Sample of my data
|
| NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS | 17 Apr 2007 03:38 GMT | 1 |
NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS I'd like some help with these problems 1) I want to get a command button on a userform in sheet 1 to
|
| if condition is met, shade cell [WORKS] but if value changes: erro | 17 Apr 2007 03:10 GMT | 4 |
ok, thanks to this here site: http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm and help from u guys, i've figured out how to shade cells based on conditions. (I couldnt use Conditional Format becuz there was more than 3 conditions)
|
| Charts Sheets to Powerpoint | 17 Apr 2007 02:38 GMT | 1 |
I am using some code I got from a friend and it only appears to work for embedded chart objects? I would like it to work for Charts that are in the Chart Sheet format. Any Suggestions?
|
| Sub to transform table into cols | 17 Apr 2007 00:20 GMT | 5 |
Source table is in sheet: V, cols A across to D ... , col headers in row1, data from row2 down, viz Cust# Visit01 Visit02 Visit03 ... Visit200 Cust001 Date01 Date03
|
| Scheduling by workdays only spreadsheet problem | 16 Apr 2007 23:55 GMT | 3 |
I need to create a spreadsheet which calculates project mileposts. Start date | Est. workdays | Est ready date Est ready date allowing for weekends A1 | B1 | A1+B1 |
|
| Recording a range of changed cells. | 16 Apr 2007 23:36 GMT | 2 |
I have some sheets that I need to note if any of the columns within a given row has been changed. To clarify columns A1:Q1 have data which can be changed, I'd like to have cell Srow# set to True if anyone of the items in column A-Q have been changed.
|
| filling a combo box with two Columns | 16 Apr 2007 22:42 GMT | 8 |
How can I fill a Combo Box with two Columns? Using ComboBox1.AddItem seems to only accept one column? This is what I want the Combo Box to contain: 1 Dough Petersen
|
| tabbing in code | 16 Apr 2007 22:30 GMT | 4 |
is there anyway to line up my code automatically?
|
| Create Harvey Balls in Excel? | 16 Apr 2007 22:15 GMT | 1 |
How would I create Harvey Balls in Excel? (Circles full, half full etc that I can use in a drop down selection menu)
|
| Creating a macro to swap cells but retain formatting | 16 Apr 2007 22:14 GMT | 3 |
I have a macro that I am using to swap the contents of two cells. When I use it I lose any character formatting that I have applied to the cell(s). Does anyone have any insights into how to do a swap cell macro but retain the formatting?
|
| Coding a filename into a macro | 16 Apr 2007 21:54 GMT | 1 |
I want to be able to move a selection of sheets to a new workbook, and name the file (this does not change so I would declare this as a string - I think), however, I would like the newly created file to be saved in the current directory (the directory of the original file).
|
| Print Preview + Coordinate Problem | 16 Apr 2007 21:45 GMT | 1 |
I'm having a trouble with Excel 2003, and I've looked for an answer all day without success, so I thought someone could help me. We have a workbook containing lots of info the user needs to fill. To help the user, some of those sheets have a QuickHelp routine - an "?"
|
| Lock cell and reprotect sheet after save | 16 Apr 2007 21:09 GMT | 2 |
I have a spreadsheet that tracks performance. Some info is put in by many different users. Other info is put in by our Admin team. All the cells that our Admin team updates is locked and the sheet is always protected. Is there a macro that will lock the cells that the users ...
|
| want to advanced to cell on the right but my code won't work | 16 Apr 2007 20:56 GMT | 1 |
What my macro should do is move to the next cell to the right when the current cell is occuiped. sample of my data A1 A2
|