Button control to run a macro?
I am sure there is some way of doing this, but the "Help" feature has the
solution pretty well hidden . . .
I am trying to create a spreadsheet with a button control that will "show
all" lines once the user has finished using a line selected by using a
filter.
I know how to add a button, I know how to record a macro, I just can't
figure out how to run the macro when the button control is clicked. Any
Help?
Thanks,
Dick Prenovost Tag: Finding missing numbers from a list Tag: 22401
DDEExecute
I am using DDE from MSAccess for sending commands to Excel.
I used the DDEExecute var_CHNL_no, "[page.setup(". Where can I find
the documentation for the rest of the commands Excel accepts with DDE
(like creating new worksheet, charts etc) ? Tag: Finding missing numbers from a list Tag: 22399
Shortcuts of excel
I want to perform a "horizontally page down" , switch from column 1 to
column 50 .
are there any shortcut keys perform such action?
are there any article listing all the shortcut key of excel?
thank you. Tag: Finding missing numbers from a list Tag: 22391
Linking Cells: Excel into Word Document
Greetings,
After reading through the help files for Excel 2002, it seems to me that
there is no way, except for programming, to have just a range of cells in a
worksheet be linked to a Word document.
Here is what I am attemping to accomplish: Using Word to create an extensive
document for a database proposal. Using Excel to document the all of the
required tables (since nothing has been created in Acces and I am new
databases), drawing diagrams with lines and other database objects. Would
like to be able to insert/link certain cells from a worksheet (which would
be many inserts/links) into the Word document.
Any suggestions?
Thanks,
Eric Tag: Finding missing numbers from a list Tag: 22386
pasting numbers into excel
when pasting numbers from another program into excel, i have problem
with the excel program understanding that these values are numbers
even if i go into format cells and change the format, they dont change
eg. if i change a cell to currency, that pasted cell still doesn
change.
however, if i go to the cell and hit f2 and then enter, or i jus
retype the number in over the top, then all of a sudden it works, and
can use the data for charts etc.
but ive been trying to use these numbers in a chart as is, and it won
plot the number with any value. as soon as i retype the number over th
top of it, it plots the value fine.
i have tried rightclicking and pasting special, the only 3 options
get are paste as html, text , or unicode... and all 3 dont work.
i found this problem out because i can download my pohne bill off th
net, and also at work im downloading reports off various programs an
its the same story. the nubmers just dont seem to mean anything until
retype the number.
please help somebody?
thankyou
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Finding missing numbers from a list Tag: 22385
cannot open excel file
I have an excel file that originated in excel 97. I opened it up in excel
2002. I emailed it to a few people and some can open it and some can't.
One person that can't open it has excel 97. the Save as Type: is Microsoft
Excel 97-2002 &5.0 /95 Workbook (*.xls). Any ideas as to why he cannot
open the file. The icon next to the file isn't an excel file. Tag: Finding missing numbers from a list Tag: 22374
formatting text/numbers
I have entries in a column that are listed as a "credit" (ie. $1234CR). I
want to reformat these entries as -$1234 so that calculations can be done
correctly. Any ideas?
What about TRIM and multiply by -1? Tag: Finding missing numbers from a list Tag: 22371
Excel - Paste Special Values Question
Ok......I need some help. I am using Office XP, service pak 2.
In Excel, I highlight information, right click and select copy. If
go to another sheet in the same workbook and right click and selec
Paste Special values, I get the the Paste Special Values Menu.
[image: http://www.mrexcel.com/mec000526a.gif]
If I go to a new workbook, right click and select Paste Special Values
I get a differen't Paste Special Values screen. On the new screen,
have tried each option and nothing works.
[image: http://excelhelp.freeservers.com/special_values_error.gif]
Any ideas on why it is doing this? Is there a setting?
Thanks in advance,
Quanch
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Finding missing numbers from a list Tag: 22367
Counting populated rows in excel
I have some rows populated in an excel sheet. Is there a way I can writ
a macro to count the number of populated rows
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Finding missing numbers from a list Tag: 22366
excel2002
Hi all
Sorry if this has been covered before: Is there any way to make an excel
workbook always open on the same worksheet immaterial of where you actually
saved or closed the workbook?
Many thanks
elwyn Tag: Finding missing numbers from a list Tag: 22360
Disable Clipboard
Hello. Using Excel 2002, how can I disable the clipboard to keep popping up
when I copy a cell?
Un-check the 'Show Clipboard Automatically' option but still opens everytime
I make a copy.
Better yet, is there a way to uninstall that feature at all?
Thank you very much. Tag: Finding missing numbers from a list Tag: 22359
Time * Rate of pay
I'm trying to use excel as a paycheck calculator. So far, I have star
time, finish time, finish - start time to calculate hours, but I can'
seem to multiply a time and a dollar value. Can someone please help m
with this
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Finding missing numbers from a list Tag: 22348
hlookup, same dates in row I'm looking up from
Hello all,
First, thanks to all for making this such a worthwhile resource. I
feel humbled whenever I have to post a question and I get such
thought-out responses.
Here's my latest scenario. I have 23 sheets. In one sheet, I enter
purchase orders. Each Item that is being ordered has its own sheet
where certain information (order date, number, arrival and quantity)
from those purchase orders is automatically updated and further
tracked.
Purchase Order Entry Sheet
PO Date 9/12/03 11/20/03 11/20/03 12/14/03
PO Number 123 234 345 456
PO Est. Arrival 9/30/03 11/30/03 12/5/03 12/30/03
Item 1 45 100
Item 2 222
Item 3 11 18
Item 4 24
Each Item has a sheet. I have HLookups looking at the PO Date on the
PO Entry Sheet and filling in how many items were ordered. The problem
comes when I have two orders with the same date (see 11/20). Only one
of those orders is picked up by the HLookup. I need it to find both so
that all orders are accounted for on the Item sheets. In my example
above, I would have four Item sheets, but only (in my situation) is
the 2nd order on 11/20 recorded in the item sheets. Item_1 and Item_2
orders for 11/20 are not being picked up.
This is very difficult to explain. I hope I've made sense. I'm using
Excel 2002.
Please let me know if you need more information. Thank you one and
all!
Christine Flott Tag: Finding missing numbers from a list Tag: 22310
Copy formulaS between Workbooks
This might be some sort of follow up question from Ken Runge post "Cop
formula between Workbooks" from Oct-23-2003. I would like to copy som
formulas from one workbook to another without getting a reference t
the original workbook
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Finding missing numbers from a list Tag: 22309
Error Opening a File
Hi,
I am trying to open a existing text file to write some
text,but the Existing Text file is already open.
So I can't write anything using VBA Macro for Excel 2000.
I am getting error while Opening the Text file.
Is it possible for any one to guide how to handle this
Error ??
I am using following code.
here fileName is already open in some other applicaiton.
Open fileName For Output Access Write As #fileNumber
How to handle this Error . I want to display an error
message saying that The file is already open ..
Thanks
Mili. Tag: Finding missing numbers from a list Tag: 22307
Error Opening a File
Hi,
I am trying to open a existing text file to write some
text,but the Existing Text file is already open.
So I can't write anything using VBA Macro for Excel 2000.
I am getting error while Opening the Text file.
Is it possible for any one to guide how to handle this
Error ??
I am using following code.
here fileName is already open in some other applicaiton.
Open fileName For Output Access Write As #fileNumber
How to handle this Error . I want to display an error
message saying that The file is already open ..
Thanks
Mili. Tag: Finding missing numbers from a list Tag: 22306
Custom Menus
Hello,
Does anyone know if it's possible to share custom menus.
My company run a NT network and everyone uses Excel. I want to create a
custom menu in excel which is managed centrally.
Anyone got any suggestions?
I do not check my allanmartin@ntlworld.com account. I only use it for New
Groups and I ignore it as it has been harvested too many times.
Please respond to the newsgroup and I will check it daily.
Many thanks.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003 Tag: Finding missing numbers from a list Tag: 22302
.XLS > .HTML
Hi,
I have some Excel workbooks I'd like to prepare for web viewing.
However, the built in publish to web feature in Excel 2002 (XP) never gives
the graphs, AutoShapes or WordArt from the original file. MHTML archive
format gives a file bigger than the original, which would take quite some
time to download over a dialup connection.
I've heard the latest version of Office works better in terms of getting my
files onto the web, is there any truth in that?
Thanks
Dylan
ps. If there are any glitches in the code produced I can correct them as I
have Dreamweaver on the same system. Tag: Finding missing numbers from a list Tag: 22299
Row Numbers
Hi,
If I delete a row in excel i.e. row 7 then the row numbers go out of sync
i.e.
5
6
8
9
etc
is it possible to correct this?
Thanks for your help Tag: Finding missing numbers from a list Tag: 22294
Displaying a + sign on positive numbers
I am calculating the percentage increase / decrease on two numbers. If the
difference results in a decrease of, say 2.2% it is displayed as -2.2%
If the result is an increase of 2.2%, then 2.2% is displayed. Purely for
formatting reasons, I wish to display the figure as +2.2%
How can I set this up so that positive numbers contain a plus sign, whilst
maintaining the cell as a number? I can carry out an IF statement that will
add a "+" to the figure if it's greater than zero, but this ignores any
formatting to a set number of decimal places.
Any help will be appreciated! Tag: Finding missing numbers from a list Tag: 22290
XLXP: Text cut-off at end?
Hi,
Pls. download the attached MSEXcel File.
Look at point # 16, the "aaaaa's" at the end are cut-off.
Pls. can you advise me why this is & how I can fix this problem.
Thanks
+----------------------------------------------------------------
| Attachment filename: test_file.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=355002
+----------------------------------------------------------------
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Finding missing numbers from a list Tag: 22285
Calculations in Excel
Hi every1!
If u can, plz help me with this excel question (its been bothering me
for ageas already!):
Total Available: 25
Runout date: ???
A B
Date Quantity Required
1/6/2003 6
3/7/2003 14
4/8/2003 9
8/11/2003 6
How do i make it show the date that the food runs out on (4/8/2003 in
this case) and the day before it will run out (3/7/2003 in this case)?
If u can help, then plz reply!!
Thx in advance
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Finding missing numbers from a list Tag: 22284
Please help
Hi,
Once again I need your help guys,
Ive got to colums of data :
3 4
5 7
5 8
6 9
etc. etc.
I want to set up a formula that determites if A and B are inside some
different ranges, and
thereby set C to a value. I tried with IF but i got 12 sets of ranges...
Is it possible to do in a matrix ?
Best regards,
Sauer Tag: Finding missing numbers from a list Tag: 22268
Selecting First AutoFilter Row
How do I select the first filter row of an autofiltered range?
I tried going to the top of the range and doing an offset:
range("E1").Activate
ActiveCell.Offset(1, 0).Activate
but that did not work.
If E1 was the header row and E150 was the first filtered row, this code
above would activate E2. Tag: Finding missing numbers from a list Tag: 22266
excel 2003 - navigating regions
i am going through the "inside out" book for excel 2003 and need help
in figuring out why i can't navigate regions as described in the book.
- i open the regional sales.xls file (that is shipped with the book)
and select a cell (say a4)
- click ctrl+right arrow ... expect to get to the next active cell
(b4) but the worksheet scrolls to the right but no change in
selection. doesn't seem to matter what document i open
very strange Tag: Finding missing numbers from a list Tag: 22265
Pivot Table -- Don't want first column sorted at all
I have created a pivot table with totals for 20 years, one in each column.
The data in the source table appears in a certain order, WHICH I'D LIKE
PRESERVED in the pivot table.
The pivot table, however, wants to sort things alpha or something. That
is bad. I don't want that.
How do I have it NOT sort the categories down the first column?
Thanks.
Rob Miller
Oakland CA Tag: Finding missing numbers from a list Tag: 22262
printing of columns HELP
hi there
i am sure this is a simple question
I have a list of names and phones (column A and B) I would like to
print several columns to fill the page (i.e. just how a phone book
looks
how do I do this)
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Finding missing numbers from a list Tag: 22259
conditional formating to highlight current week?
Hi,
I have a row of week beginings (mondays) for the year and i want to use
condition formating to change the format of the cell that contains the
current week. something like...
if cell value is between today()-6 and today() then special format
however i cant get it to work, i have days where two weeks are
formatted?
any ideas?
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Finding missing numbers from a list Tag: 22250
hyperlink to existing excel file
When I create a hyperlink to an existing excel file and then click on it,
explorer opens to the folder that the file is in instead of the excel file
opening. Just to test I pointed it to a word document and the doc file
opened fine. How do I get a hyperlink to open the excel file? Thanks. Tag: Finding miss