limit number of rows 7 colloms in a worksheet
is there a way to limit or set the number of rows & collums in a
Message posted from http://www.ExcelForum.com/
"davidbrowne17" <email@example.com> wrote in message
> is there a way to limit or set the number of rows & collums in a
> worksheet ?
No. All worksheets have 256 columns by 65536 rows.
You can hide unused rows/columns. But why bother?
Put this in the ThisWorkbook code module. Adjust to suit the area.
Private Sub Workbook_Open()
Wo...NUMBER FORMAT #9
CREATE A NEW NUMBER FORMAT SO THAT THE SELECTED DATES WILL APPEAR ONLY AS THE
FULL NAME OF THE DAYS OF THE WEEK.
...Why are my numbers disappearing in excel yet it totals them?
I have a spreadsheet that I have filled out the individual cells with number.
These cells are totaling correctly, however when I open the spreadsheet
the individual number I entered are showing blank.... I moved my mouse
around in the spreadhsheet and all of a sudden the numbers appeared and then
Check the font color. The default is black.
Also check the cell color. Default is "no fill".
If the font color was changed to white, you would only see the content after
you select the cell.
Remember to Click Yes, if this post helps!
"Donna S...Auto Reply #13
Can someone please let me know how to set up an Auto Reply
on my email...I will be away from my office on vacation
and I would like to set up an auto reply to advise anyone
trying to contact me that I will be away.
I am currently using Outlook 2000.
Please help if you can.....You have no idea how long I've
been trying to figure this out
You can use Outlook Rules Wizard or one of the third-party automatic rules
processing addins. See http://www.slipstick.com/rules/index.htm and
Sue Mosher, Outlook MVP
Microsoft Outl...Auto forwarding email
Is there a way I can have outlook automatically forward email that comes
into my inbox and have it sent to a different email address. Any help would
...No account number shown in printed checks
Using Money 2007 Deluxe.
Printed a series of checks from MS Mmoney this morning, but the account
numbers didn't print on the checks. Each of the payees has an account number
entered in the appropriate place, in the "Go to Payees" detail listing.
Can't figure out what's going on here!
Thanks for any assistance.
On Sat, 17 Mar 2007 08:37:03 -0700, Dave M. <DaveM@discussions.microsoft.com>
>Using Money 2007 Deluxe.
>Printed a series of checks from MS Mmoney this morning, but the account
>numbers didn't print on the checks. Each of...How to remove dashes and slashes form a sequence of numbers & lett
I have a sequence of numbers in column D and I require to extract just the
numbers and letters to column E.
Any pointers would be much appreciated.
Put this in E1:
and copy down as required.
Hope this helps.
On Oct 14, 11:34=A0am, Celticshadow
> I have a sequence of numbers in column D and I require to extract just th=
> ...Windows XP Start.wav / Start Navigation sound isn't working
Hello, and thank you for reading my post.
For some time now, I noticed that my PC's "click sound", which normally
appears while surfing in IE 6, wasn't working. I'd learned that I'd need to
visit the Start Navigation sound in Control Panel-->Sounds and Audio Devices,
and select Windows XP Start.wav...which I'd do, but it wouldn't stay in place
as soon as I clicked on "Apply".
Because of this issue, and others, too, I reinstalled a "clean" version of
Windows XP SP2, and then upgraded it (&, by extension, IE 6) to SP3,...Money cannot start
Can anybody help me? I cannot start Money. There is an
error when I open Money Deluxe 2004:
This application has requested the Runtime to terminate
it in an unusual way. Please contact the application's
support team for more information.
In microsoft.public.money, Pham wrote:
>Can anybody help me? I cannot start Money. There is an
>error when I open Money Deluxe 2004:
> Runtime error!
> This application has requested the Runtime to terminate
>it in an unusual way. Please contact the application's
>support team for more information.
...Auto Repsonse for Incoming Email
Sorry to ask this question but I can't seem to locate an
answer in the archives.
I have a distribution account account called
firstname.lastname@example.org. Emails are distributed to 5 users in the
service department. The manager of the department would
like an auto response generated for all new email
acknowledging receipt of the email and thanking the
customer for their business.
We are running a mixture of OL 97 and 2000 on an Exchange
5.5 server. I have tried setting up a rule to reply to
any inbound email to the service account but, it is not
replying to the sender.
Any help would be...Jump to start of next row teaser
can anyone assist in telling me if there is either :-
a) a shortcut key
b) a macro
c) none of the above but another solution to
jumping to the beginning of a new row on pressing a key. For example,
after completeing cell m10 can you press enter (or any other key) and
the cursor will automatically go to cell a11, then after you get to
m11 it jumps to a12 and so on?
Just to make things a little trickier, I know you can do this using
the protect worksheet etc function, but I also have the data filter
running which doesn't work when the protect sheet function is on. If
there is a macr...trying to start a service with VBScript on Win7
I'm using Windows 7 Home Premium. I have a service which is set to
manual -- I only need to run it when I'm doing development and thus
not take up resources.
At any rate, none of the previous scripts I have, nor the samples from
the ScriptCenter will start this script. When I try to make a batch
file, from command line I get:
[SC] StartService: OpenService FAILED 5:
Access is denied.
From searching on Google, I guess this is a permission problem but
since the home premium flavor of Windows 7 doesn't come with GPEdit,
I'm at a loss what to do.
Is...Publishing Auto installing with refresh
I installed Office Beta 2 Refresh. I originally had not
installed Publisher. However, after installing the
refresh, Publisher was automatically installed. Is the
refresh supposed to do this?
Consider you got yourself a bonus. At least now you will have the chance to
evaluate a decent program.
You should be ashamed of yourself not installing Publisher originally.
...Conver General number to Currency
I have a column of numbers in Excel 2003 that are of General type. I
need to insert a decimal point two positions in from the right of the
existing number. When I do that however by using Format > Cells and
changing it to Number with 2 decimal places, or to Currency format, it
adds a .00 to the existing number instead of inserting a decimal point
into the existing number, e.g., 999955 come out as 999955.00 or
$999,955.00 when what I really want it to do is 9999.55 or even
Put 100 in an empty cell, select the numbers, do edit>paste special and
select divide, ...finding differing numbers.
How do I in a column of numbers some in duplication, how can i get a list off the entries which reflects these numbers but not in duplication. ie "numbers" 1, 1, 2, 3, 4, 5, 1, 5, 3, 5, 2, 1, 2. "result" 1, 2, 3, 4, 5
- select your column
- choose 'Data - Filter Advanced Filter'
- choose a new range and 'unique entries'
> How do I in a column of numbers some in duplication, how can i get a
> list off the entries which reflects these numbers but not in
> duplicat...Last Record Numbering
I need to find a way to display in a form text box the highest numerical
value entered in any one of four fields for the last record entered.
For example: If
Field_1 is 0001
Field_2 is 0008
Field_3 is 0005
Field_4 is 0004
When the form is opened, the textbox would display the number 0008. The
textbox should display the highest of the four fields of the last record.
Message posted via AccessMonster.com
Already responded to in another newsgroup.
It is rarely necessary to post and re-post the same question in multiple ...removing spaces between the numbers
When copying number from Navision account program to Excel, it copies
numbers with spaces as text, but not as numerical values.
Such value: 1 109 014,08 is copied as text.
One possibility to set the number actually to a numerical value is to delete
the spaces within the number, so after doing that it looks as 1109014,08.
Then i can add, multiply, divide this number with ease.
Is there a automatic possibility how remove those spaces?
Is there an alterantive?
Use Search and Replace - highlight all the cells, then Edit | Replace
(or CTRL-H). In the Find box type a single spac...Negative Number Formats
Can anyone help? I have Excel 2003 and despite setting=20
all regional options correctly and specifying number=20
formats as (99), (=A399) etc I still can't get Excel to=20
display them in parentheses. I seem to remember from=20
Excel XP that you have to install/uninstall=20
certain "foreign" language options but can't remember=20
what. Please e-mail if you have the key!
I'd double check that windows setting:
Windows Start button|settings|control panel|Regional Settings
Currency Tab|Negative Number Format
(that was the path I used in Win98.)
Paul Handley wro...[$-409] in Custom Number Formats
I've seen [$-409] in some number formats and I was looking through the help files to see if I could find out what it means. I
couldn't find anything on it. I've also seen [$-F800]. Does anyone know what these codes are for or where I can find info telling
me what they are for and any others that can be used?
Thanks for any help anyone can provide,
This was covered in the Daily Dose of Excel blog about a month ago:
Jon Peltier, Microsoft Excel MVP
Peltier Techn...count number sunday+saturday in many week
I don't know what function can count number sunday+saturday in range of
weeks. Please help me. Thanks
Use the function Weekday(A1) to give the day of the week (Sunday=1,
If you haven't this function you have to activate the Add-Inn Analysis
Toolpak as follows:
Tools - Add-Inns - Analysis Toolpak
To calculate the number of Sundays and Saterday:
=CountIf(Range,1) + CountIf(Range,7)
"chu" <email@example.com> wrote in message
> I don't know what function can count number sunday+saturday in r...When starting Outlook Error:Unable to open your default e-mail fol
I just installed Outlook 2003 and when i open it a box comes up saying
Configuring Outlook with "Migrating Account Settings" highlighted in a list.
Then an error pops up saying:
Unable to open your default e-mail folders
This error can occur if you attempt to run Outlook from a Terminal Server
session when the OST file is in use by the console session. To access this
instance of Outlook, exit the current Terminal Server session and start a new
session by using the following Run command (click Start, then click Run):
You must be an administrator on the computer ...TTF Number already in use error
Working on a CBM Batch, I'm choosing a specific TTF document number for a
telegraphic transfer payment. Receive an error - number alreay in use. The
number has never been used and does not reflect in any enquiry or report on
TTF document numbers.
First checklinks on (CM Transactions) then check table CB100000, make sure
that the number does not exist there, if it exist then it have been used
before and deleted.
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
firstname.lastname@example.org...Maximum/Minimum number of records on import
My database is set to import a CSV. Is there a way to not allow a CSV
file to be imported, and bring up a message box if the CSV file has
less than 30 records or more than 500 records? I think it involves
something to do with Select Case, but I'm not quite sure where to take
it from there.
Thank you for your response. I already have the actual importing
process working perfectly the way I want it. But I was wondering
whether or no there was some type of code to stick in there, to tell
it not to allow importing of a CSV file with less than 30 or more than
500. If there is a code that I ca...Fax Numbers In Exchange 2003 OWA
When a user is using Exchange 2003 OWA and wants to view another users Fax
Number they cannot see it. All they can see are the users: Name, Alias,
Company, Address, City, State, Postal Code, Country/Region, Title, Company,
Department, Office, Phone and Mobile Phone details, no fax number.
Can anyone please tell me how to make the fax number visible in Exchange
...How to measure the number of emails sent to external domain?
Can we measure in total for each person or each DL the number of email sent
to external people in a month?
We are running Exchange 2003 SP2.
Count in mail log.
MCSE+Internet, MCDBA, MCP
"MLi" <email@example.com> wrote in message
> Can we measure in total for each person or each DL the number of email
> sent to external people in a month?
> We are running Exchange 2003 SP2.