| Thread | Last Post | Replies |
|
| clear cells containing specific values | 21 Sep 2007 22:00 GMT | 7 |
If someone can help me on this: I have column A row1 28th street market
|
| Aligning buttons | 21 Sep 2007 21:38 GMT | 1 |
I have a group of buttons in the spreadsheet. Is there a way to align the buttons. I've been just kind of eyeing them in the past to get them straight. Thanks,
|
| VBA - array or collection literals? | 21 Sep 2007 20:52 GMT | 2 |
Currently, I have written a function to do some sort of pattern matching: Dim delims As New Collection delims.Add " <"
|
| code is not selecting correct range | 21 Sep 2007 20:42 GMT | 3 |
I have a strange problem -- the macro is not selecting, copying or pasting to the correct ranges. When I do a F8 step by step debug review, it seems as if it actually skips the Range(...).Select code. The new select and paste ranges that are not be selected properly were
|
| macro for arranging by Contract # | 21 Sep 2007 20:38 GMT | 3 |
Hello experts, I am trying to arrange information by contract # or by date. I produce a material everyday and input the information into the spreadsheet the latest is the last line but the contract #'s vary per day (See example #1). I want
|
| complex IF statement | 21 Sep 2007 20:34 GMT | 5 |
In cell $E$70 I have a data validation drop down list which allows the user to select a percentage between 0% and 10%. I am trying to get cell $D$70 to read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product Subtotal at 2% discount" when cell $E$70 is 2%" etc.
|
| Change the worksheet tab name updates hyperlink on first page? | 21 Sep 2007 20:32 GMT | 2 |
The subject essentialy is what I want to accomplish. Also if when I update the tabs (rename or add a new one) the list of hyperlinks adjusts automatically? If it needs to work the other way around that would be ok as well. (hyperlink edits result in tab name edits and/or ...
|
| select listbox item | 21 Sep 2007 19:27 GMT | 1 |
hi, i would like to know how i can select a listbox item using vba. i tried: for x = 0to sheets("sheet1").listname,listcount - 1 sheets("sheet1").listname.item.select
|
| Pick value off sheet list for VBA code determination | 21 Sep 2007 19:10 GMT | 2 |
Apologies for the cross post. Here is a sample of VBA code used to place a value in a cell base on the value entered in the cell previous If LCase(.Value) = "capital" OR _
|
| Please help with coping cells | 21 Sep 2007 18:24 GMT | 4 |
I have the following sample of data in an excel sheet. This lay out is repeated for couple hundred rows in exactly the same fashion. ******************************************************** Building Primate Clinic CRV($000's) $603 Building Number 504 GSF 2,455
|
| convert multicolumn/multirow table into two structured/formatted columns => feasible? | 21 Sep 2007 18:10 GMT | 7 |
I know this is an extremely tough one and I don't expect here any final answer on this - some enlightening guidelines (f. ex. if it's feasible...) would be already great! I have a huge excel table (database) that involves child (unique) and parent
|
| runtime error 1004 | 21 Sep 2007 17:44 GMT | 1 |
hi, i have the following code behind a button in sheet1: sheets("pivot").select range("F2").select
|
| Assigning a macro to a picture | 21 Sep 2007 17:18 GMT | 3 |
I was tinkering with an image in Excel 2003, right clicked, chose assign macro, and clicked OK instead of cancel. Now, everytime I left click on the image to try and select it, I get an error message about a macro not being found.
|
| GetWindowsDirectory in Vista | 21 Sep 2007 17:08 GMT | 2 |
I've been successfully using a programmed spreadsheet that first writes to on Windows XP that reads from the Windows Directory. I now need to use it on a Vista machine. It doesn't seem to find the Windows Directory. How do I find it?
|
| Code modification? | 21 Sep 2007 16:52 GMT | 2 |
I was graciously provided a macro that deletes all rows not having certain values in col A. In the following line: ArrNames = Array("Agt", "Agent") Is it possible to add a wildcard to "Agt"? Those are just the first 3
|