| Thread | Last Post | Replies |
|
| End sub routine, move to next | 10 Nov 2007 22:38 GMT | 3 |
I am new to VBA, but have been able to do some automation in a workbook partially by recording a macro, by research, and a few questions to this website. Almost finished, but I need a little more help. On a worksheet in my workbook, I have a variable range, which, once found, I ...
|
| Find a picture on a worksheet | 10 Nov 2007 22:38 GMT | 4 |
I it possible to serach for a picture on a worksheet via VBA, I'm trying to see if a particular picture is visible on a worksheet if not then copy from another another worksheet? Thanks!
|
| "Or" statement not working | 10 Nov 2007 22:08 GMT | 22 |
This Macro excerpt is based on a "Check Cell Content before continuing..." discussion with Bill Renaud back in October. I works great (thanks Bill) with one exception. If the cells are changed in reverse order of my "Or" statements (Conditions
|
| Countdown Timer - not stopwatch | 10 Nov 2007 21:35 GMT | 9 |
How do I write a countdown timer macro in excel if I have an end date / time that i want to countdown till? For example, I have in cell A1 - "12/31/2007 11:59:59 PM" and I want to display a countdown timer starting in A2 showing "X months Y days Z hours AA Minutes BB seconds ...
|
| 2 Lists but different time frames. | 10 Nov 2007 21:25 GMT | 3 |
This is a snipet of my spreadsheet, this goes one untill 2007...: A B C D E 1 GDP GDP 2 Jan-1981 5,307.5 1981q1 5,307.5
|
| Average data and delete a row-need help | 10 Nov 2007 21:21 GMT | 2 |
Hello All, I average the data in cells B6 to B36 and place average one cell over in C36. Once this is done, I want to delete row 6. I get an error at line "selection.Delete shift:=xlUp" of "Object variable or With block variable not set". Don't understand what is wrong. Below is ...
|
| compile error, need to simplify/shorten | 10 Nov 2007 21:05 GMT | 2 |
I know this isn't the best way to go about this, but I a learning here. . . I am using this to update stock prices from a Google Finance query. I have a list of about 200 stocks, and when I run the below query for
|
| Making 5 Minute Wind Averages | 10 Nov 2007 20:04 GMT | 3 |
Right now, I have data that is in 1 minute wind speed and direction (in degrees) averages. I need to convert it to 5 minute averages (that is the average from time 0-5min, 6-10min, 11-15 min and so on). I've attempted to use the text and indirect functions to do this, but it ends ...
|
| From Column A get Text from Colum B | 10 Nov 2007 19:29 GMT | 4 |
I have text cells in column B, The text cells in column B start with some word or words followed by a space-space then the rest of text. Example: Cell B1
|
| Scattered Cell entries into one Column | 10 Nov 2007 18:55 GMT | 3 |
What I have is scattered cells entries. Each row has an entry I want in a specific new column. I am working with 'Excel 2003' and don't know squat about programing. I have tried filtering and do seem lost at this point to consolidate all this data in cells to a specific column ...
|
| Using VBA to print a range | 10 Nov 2007 18:54 GMT | 5 |
Hi to all out there Hi I was wondering if there is a way of writting VBA code to print a range in Excel 2003 with a page title this would all happen from a command button. I could use a macro but I have always been told that VBA is the better way to
|
| Copy formula to cells on the basis of value in row 1 | 10 Nov 2007 18:13 GMT | 3 |
Thanks for the help. In a sheet called "Metrics", I have a matrix where row 1 is dates, So I have different dates from B1:BD1. Now I enter a date in one cell in a different sheet. I want a macro to
|
| Speed Up this Macro? Part 2 | 10 Nov 2007 17:29 GMT | 6 |
Hi, Faisal. I have one more question. When I protect the sheet, most of it anyway except quantities and discount, then I run this macro. I come up with an error on the line below. Any thoughts? ___________For Each cell In rng_____________________
|
| Can Excel 2003 VBA module be renamed | 10 Nov 2007 15:20 GMT | 2 |
I am new to Excel VBA. Can an Excel VBA module be renamed like in Access so I have more meaningful names that Module1, etc?
|
| Spreadsheet to access | 10 Nov 2007 15:01 GMT | 2 |
Please,help When i run the code below i get message: "the connection can not be used to perform this operation. it is either closed or invalid in this context
|