|
Copy/Paste using a macro that identifies occuoied range
I am working in the macro below. The purpose of the macro is to copy and
paste a range from one file to another. So far that part of the macro as
it is works perfect. However, I need to produce a spreadsheet in which I
copy another range but I would like the macro to be able to determine if
the range B5 is occupied them move and paste to range B9, if B9 is
already occuoied, then paste to range B1...
|
2 |
13.03.2006 00:51:45 |
|
|
How do I download and open a CSV file in Excel 2000?
From a research website I use, there is a link to download a CSV file into
Excel. On my other computer, when I run this link, the CSV file opens with
all the columns populated properly. That is, all the information in the
proper columns. For some reason, on this computer, when I run the same
download, I get a spreadsheet with all the information in the column A.
What setting change...
|
2 |
12.03.2006 23:32:22 |
|
|
lost password
I have a sheet that I both read protected and write protected with a
password. Now I lost the password. I know I am an idiot, but I don't
know if anything at all can be done?
Thanks,
Peter
...
|
6 |
12.03.2006 03:35:39 |
|
|
Arrow keys in Excel 2002/running Windows XP
Hello,
When I use the right arrow in MS Excel 2002 it doesn't go to the next cell,
but jumps several columns over and about 50 lines down. When I click on the
left arrow it brings up the "save as" box. Please help....
I use MS Excel at work all of the time and this doesn't happen.
Heather...
|
1 |
11.03.2006 20:46:28 |
|
|
Autofit...failing to wrap in print version
I maintain a set of spreadsheets, each with multiple tabs, that house claim
related information that is updated weekly by our specialists. One of those
fields is a text field set to wrap and autofit. However, in two different
spreadsheets (one tab each) the row height shows correctly on screen, but
cuts off the text in the printed version. This is not due to the character
limitation. ...
|
2 |
10.03.2006 23:06:26 |
|
|
Turn off "Reviewing" toolbar that opens at eXcel start?
When eXcel 2003 starts/opens the "Reviewing" toolbar opens also. How do I
turn off this feature so only the "Standard" & "Formatting" toolbars are
open; without having to go to the View-Toolbar menu item each time and
manually unchecking the box?...
|
3 |
10.03.2006 18:41:28 |
|
|
2003 Automatic Query Refresh
I'm using Excel 2003 with Data Queries. Each time I open my spreadsheets
that have data queries set to run automatically I get a box advising me of
the "Query Refresh" and asking me if I want to "Enable Automatic Refresh" or
"Disable Automatic Refresh"!
How can I set this to "Enable" for all spreadsheets as a default?
I've looked in tools/Options but I assume I'm missing it somewhere!
...
|
1 |
10.03.2006 11:32:27 |
|
|
lost file SKU011.CAB
My Excel programm won't run anymore because, all of a sudden the SKU011.CAB
file cant be found, The whole Office 2003 for Windows XP was installed on my
computer when I got it, so I don't have any back-up. Where/how can I get this
lost file ??...
|
2 |
09.03.2006 19:49:25 |
|
|
Formula for agenda to create start/stop with projected time of ev
I saw this in the templates for agendas. Went back the next day and could not
find it. It was for excel, a formula that is entered and you put the start
time then the stop time and the projected time, then the formula would
calulate all the times with just the projected time to create the agenta.
Could someone help?????Thanks...
|
1 |
09.03.2006 14:39:30 |
|
|
Excel - should handle UNLIMITED records like QuatroPro!
The 65,000 record limit in Excel is archaic. Works fine for business, but
the scientific community is shackled with this 1980's artifact from 640K DOS
memory constraint. While the programmers are at it, fix the bug in Access
that only exports 65,000 records with a fixed 2 decimal place number.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
su...
|
3 |
09.03.2006 04:58:26 |
|
|
VBA Help Links Not Working
Hi, all,
I upgraded to Excel 2003 (and Office 2003) recently and am using WinXP
(Service Pack 2).
My problem? Many of the links in Visual Basic Help don't work, the ones that
say "Visual Basic for Applications" in parentheses. Others do work. I
uninstalled VBA and reinstalled it and still no-go.
Any help out there? Seems I'm missing something rather "basic" (pardon the
pun). But t...
|
1 |
08.03.2006 23:04:36 |
|
|
HOW DO I ADJUST ROW HEIGHT BY PIXEL?
on one computer i can adjust excel row height pixel by pixel. on another i
can only adjust by points in .25 increments. 1 pixel = .75, 2 pixels = 1.5 vs
1 pixel = .60 2 pixels = 1.20. how do i change this?...
|
1 |
08.03.2006 20:44:18 |
|
|
VB in EXCEL VS WORD
I'm working in Excel and I can't get it to recognize and object from the
Word Object Library. I've allready selected Word 10.0 Object Library.
The "Selection" object works in Word …but when I type it into the script in
Excel…it isn't recognized. Does anyone know how to get the Excel script to
recognize the "Selection" object.
...
|
1 |
08.03.2006 20:03:27 |
|
|
Tools Options
I recently re organised my files.
Opened excel
Went to Tools Options to make some changes
Excel came back with
Cannot access directory c:\Data File\2006
Why can't I change any of my settings?
even in new files that has no data?
Frank
...
|
2 |
08.03.2006 12:12:11 |
|
|
How to replace null values with zero?
I know how to do this in an Access query... I just don't want to take my list
of data over there and bring it back to Excel. Is there a function that can
do something like an IF statement:
=IF(IsNull(A1), A1, 0)...
|
2 |
07.03.2006 22:01:30 |
|
|
On template Bus. Card How to make one Card into all 10 cards
How does one take one designed Bus. Card on a 10 card template and make all
10 Bus. Cards the same without having to make each Card...
|
2 |
07.03.2006 20:09:17 |
|
|
Reviewing Problem
Help...I have a user that has a PC in the office, but from home uses a remote
terminal session back to our server to use Excel. On the PC she has Office XP
and on the terminal server we also have Office XP. When she opens Excel
documents from home through the remote session she is getting the reviewing
tool bar and she has formatting issues. If you open the doc from the PC it is
fine. Th...
|
1 |
07.03.2006 16:52:07 |
|
|
I want to lock the printing preferences in a shared workbook
I can lock cells and views but don't know how to lock the print to be only
one page wide....
|
2 |
07.03.2006 16:51:09 |
|
|
Out of Memory
I recently purchased a new Dell computer with 2 gig of RAM. I have two large
Excel files that I need to have open simultaneously. I can open these at
work on a machine that has only 512 meg of RAM but I can't open them on my
new machine. I am using Office 2000. I keep getting an error message that
says that I am out of memory. Then, I downloaded the trial version Office
2003. I can...
|
2 |
07.03.2006 16:01:58 |
|
|
SCROLLING IN EXCEL
Just installed WINDOWS XP Pro and upgraded EXcel to 2003, I find that on
large spreadsheets scrolling using the arrow keys is painstakingly slow even
though the file is on a local drive....
|
2 |
07.03.2006 15:42:01 |
|
|
Excel 2003 file origin
When using the text wizard , How would you set the file origin default to
Windows ANSI. Excel 2003 tries it's best to figure out what file origin code
and is typically incorrect....
|
1 |
06.03.2006 21:58:42 |
|
|
Data validation function and drop-down lists
I am sending this to several newsgroups, because I am not sure which one
is the most appropriate.
I am using the "Data Validation" function of Excel to create drop-down
lists. Is there any way to control the font size of the items in the
drop-down list without changing the zoom (view) function of the whole
spreadsheet?
Thank you.
Colleen...
|
4 |
06.03.2006 00:44:01 |
|
|
Font Colors
Why do font color options change depending on worksheet used. I have
capability of "x" colors to use. Then when I open same document and/or
others, the font colors have changed. For example, red & brown are available
one time, then not available again. When you go into "format" to change
color, red & brown are not an option to choose....
|
2 |
05.03.2006 02:08:39 |
|
|
How to I stop displaying documents under Document Recovery Pane
Excel is showing documents in Document Recovery pane when I re-open Excel
after a crash. Is there any way not to display any documents or not to
recover any documents?
We are launching excel in hide mode and after few crashes it is trying to
open Excel in safe mode resulting a pop-up. We don't want to see any pop-up's....
|
2 |
05.03.2006 02:03:09 |
|
|
Printing question
Hi all, I have a very long worksheet, it equates to 468 pages printed. One
row extends over two pages, and I always print the top row as a header on
every page. The header goes from 1-15 on the first page and 16-32 on the
second page. Let's say I wanted to print out my long worksheet so 1-15 would
be on one side of the sheet, and 16-32 would be on the other side. Would
there be a way...
|
2 |
04.03.2006 11:50:02 |