|
Macro Error in Command Button
I have recorded a macro that runs fine when I use the Macro Run command, but
when I copy the macro text and assign it to a command button it gives an
error. The following is the macro:
It gets hung up on the 2nd line (Rows...)
Any idea why it would work as a macro and not when placed into a command
button?
Sheets("Jacobs-Planning").Select
Rows("1:343").Select
Selection....
|
5 |
12/31/2008 4:25:54 PM |
|
|
How to run Solver while viewing a graph?
(windows XP, Excel 2003)
The outset:
I am running a complex solver problem (typically takes a couple of minutes
to hours) the results are then fed into the 20 or so cells solver may change.
These cells compute a graph in the same workbook, but on a different sheet.
(The presets of the Solver are fed in by a macro)
So far everything goes along fine.
Basically what I want to do is: ...
|
10 |
12/31/2008 4:25:00 PM |
|
|
Summing data in one column based on date in another column
Hi
I need something that would sum up column B only when it shared a column A
name...
e.g.
A3= Tom B3= $10
A4= Jim B4 = $5
A5= Tom B5 = $5
A6= Jim B6= $12
If possible the macro could generate a pdf that would display
Tom = $15
Jim = $17
This would be needed for multiple names (over 20), and varying currency.
Thank you for your time ...
|
5 |
12/31/2008 4:22:04 PM |
|
|
creating new workbook from one sheet
Hi,
I would like to create a new xls file made of the content of ny current
Sheet2 (not sheet1 or 3).
is it possible?
Many thanks,
Dan...
|
5 |
12/31/2008 4:15:40 PM |
|
|
rename worksheet
I have a workbook with worksheets. The first is a plan for a quoter and other
3 are
monthly reports. Each report sheet has 2 textboxes, one for month and one
for year.
Textboxes receive data from respective linked cells.
Both text boxes receive data from the linked cell which have formulas to
select a month and a Year.
I tried several codes which work perfectly when you enter the data ...
|
4 |
12/31/2008 4:10:07 PM |
|
|
view web page with links offline
Hey guys...
there is a webpage that i got info for programing on. how can i make that
viewable with links to other pages working offline? in windows xp i knew
how... but now running on vista and dont seem to figure out how..
thanx
--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm...
|
1 |
12/31/2008 3:52:06 PM |
|
|
Combining PDFs
I have a list of PDF filenames in a worksheet. There are 2 columns; each
containing a filename and 100+ rows. For each row i want to merge 2 files in
1 new file. the new filename is column 3.
as the number of file involved is quite a lot, i want to automate this task.
How can i do this in excel vba?
...
|
1 |
12/31/2008 3:39:49 PM |
|
|
excel 4 macro migration to excel 2007
i have many extensive customized programs I have written using excel 4 macro
language. I have now reached a worksheet approaching 65000 rows of historical
data. i bought office 2007 so that I will have unlimited rows.
Dilemma is that my excel 4 programs will not run. My custom buttons don't
respond on click, when I open the macro page and right click on any line to
try to run the macro st...
|
2 |
12/31/2008 3:35:24 PM |
|
|
Using a filter when sheet has VBA code
My workbook has several tabs that have a short code that changes the font
color if the processing date is more than 30 days old and whether is was
processed successfully. When the filters are not being used, it works fine.
But when the filters are used, everytime you click, there's a 2 second delay
and horizontal lines scroll through the screen. Is there any way when the
filter is on ...
|
3 |
12/31/2008 2:41:00 PM |
|
|
Delete Selected Worksheets Macro
I have a workbook with 500 tabs. 200 of the tabs are named: FI (1), FI (2),
FI (3), etc. I want to delete all tabs that start with FI.
I've tried the below without success - any suggestions? Here's what I have:
Dim ws As Worksheet
Application.DisplayAlerts = False
For Each ws In Worksheets
If ws.Name = "FI (*)" Then ws.Delete
Next
Application.DisplayAlerts = True
...
|
4 |
12/31/2008 2:20:04 PM |
|
|
Activate Sheet
Hello,
I have some code that formats my workbook which is below:
Sub Format()
Application.DisplayFullScreen = True
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Sheets("Main Menu").Select
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayWorkbookTabs = False
End With
Sheets("H1").Activate
With Ac...
|
6 |
12/31/2008 1:54:01 PM |
|
|
Copy column(s) and insert Code
All Help appreciated. Thanks so much for Helping
I have multiple sheets with information in them. In each Sheet named Total,
there is a column or columns heading named Current. For sheet with just one
"Current" that means I have one column but for those that are multiple with
Current (I merge the Columns and named them Current)
Every time I usually copy the columns or column and insert bac...
|
12 |
12/31/2008 1:47:01 PM |
|
|
loop problem
Hiya
I have a looping sub that takes 5 cells and every 0.2 seconds adds to their
values, dealing with one at each successive 0.2 second interval , so that by
the end of each second every cell has been visited and increased by the
macro once. In other words at 0.2 seconds A1 is increased, at 0.4 seconds B1
is increased, 0.6 seconds C1 is increased 0.8 seconds D1 is increased and
then a...
|
4 |
12/31/2008 11:09:01 AM |
|
|
vba solution
Hi Experts,
Happy new year in advance,
I have a sheet with huge data and some of part these data show data like this:
__field1_____field2___field3___field4___field5__
1 2008/12/30 1
2 2008/12/30 5
3 2008/12/30 4
4 2008/12/30 2
5 2008/12/30 ...
|
9 |
12/31/2008 10:56:30 AM |
|
|
Do a lookup with VBA based on criteria in three cells
Hello,
This is a bit tricky to explain. Forgive me, I'll do my best.
Based on the contents of three cells on one sheet, I would like to
know the location (cell reference, ie $B$33) of the item desired, and
then return the contents of the cell immediately adjacent to it.
Let's say the cells I want to look up are here:
A1=CommandX
A2=Room1
A3=Object3
I want to return "Desc" from ano...
|
3 |
12/31/2008 10:34:55 AM |
|
|
If statement in VBA to change formatting from % to numbers
I have column in a s/s where some numbers are currently formatted as a
percentage and others as a number, but i want to change them so that they are
formatted as numbers.
So for example in a column i have:-
A B (What i want it to return)
65% 65
63% 63
62 62
61% 61
I tried writing the below code, bu...
|
2 |
12/31/2008 10:25:01 AM |
|
|
Active Cell
Hello,
I have soem code that doesnt quite work properly and was hoping for some
guidance.
I want to colour the first column of the selected row black, so it
highlights to the user which row they are in. Then when the user moves to
another row the first column of the previous cell reverst back to no colour.
Here is the code so far:
Private Sub Worksheet_SelectionChange(ByVal Targ...
|
6 |
12/31/2008 10:16:01 AM |
|
|
Conditonally format a text box
Hi,
I have a text box in a form that will contain one of three possible options:
1) blank
2) "Go"
3) "Stop"
I am happy enough with the look of the box as I have set it up when it is
blank but is it possible to conditionally format it so that the box
background goes red when "Stop" is the value and green when "go" is the value?
TIA
Dave ...
|
5 |
12/31/2008 7:55:01 AM |
|
|
Scroll Event
Is there an Event for Scrolling in a Worksheet. I need to have a section of
the sheet change formats when it is scrolled left or right....
|
3 |
12/31/2008 7:17:01 AM |
|
|
hide and unhide worksheets when a set button on a form is clicked
hi everyone,
the link from the e-mail sent does not show the reply to the problem is sent
earlier which is:
i have aworkbook with 4 worksheets and a user form with 4 buttons, what i
would like to do is have the 4 buttons hide various worksheet tabs when
clicked by the user.
button 1 would show sheets 1 and 2.
button 2 would show sheets 1 and 3.
button 3 would show sheet 1.
button 4 wo...
|
3 |
12/31/2008 7:13:01 AM |
|
|
Step Into Macro when file opens
I have a Command Button on my Standard Menu. It has an Assigned Macro and
the macro is not functioning the way I want it to. How can I tell it to Step
Into when it first opens the file when I click the Button on the Menu. That
is the only way I will be able to tell what is going on because after that
other variables have been set so I cannot just go run the macro after the
file has op...
|
4 |
12/31/2008 6:28:45 AM |
|
|
Prada shoes (paypal payment)www.king-trade.cn )
Footwear (paypal payment)www.king-trade.cn )
Paul Smith shoes
Jordan shoes
Bape shoes
Chanel shoes (paypal payment)www.king-trade.cn )
D&G shoes
Dior shoes
ED hardy shoes
Evisu shoes
Fendi shoes (paypal payment)www.king-trade.cn )
Gucci shoes `
Hogan shoes (paypal payment)www.king-trade.cn )
Lv shoes
Prada shoes (paypal payment)www.king-trade.cn )
Timberland shoes
Tous shoes
Ug...
|
2 |
12/31/2008 6:17:01 AM |
|
|
Macro to hide rows below
I have a spreadsheet in which column A has customers' names and other columns
have other info. Some customers have only 1 row worth of info, while others
have several rows (all directly below each other). I would like to be able to
double click the customer's name and if there are multiple rows for this
customer (meaning there is no customer name directly below, but rather a few
rows dow...
|
2 |
12/31/2008 5:52:55 AM |
|
|
Worksheet tab macro
How do I create a macro that will rename the worksheet tab to reflect text in
a cell on that worksheet? And, can I change the number of characters that can
be placed on a tab? (these are 2 separate questions) Thanks
--
ERA Mike...
|
10 |
12/31/2008 4:39:02 AM |
|
|
Last key pressed
Is there a way to tell if the last action was from selecting an item off the
Standard or Formatting Toolbar or if the last action was the Ctrl+Tab press.
Thank you,
Steven...
|
1 |
12/31/2008 3:31:01 AM |