A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
increasing the number of rows of a worksheet beyond 65536? by ibu
is it possible to increase the number of rows of a worksheet beyond 65536? if yes, how? if no, any workarounds? I need to read in a text file in CSV...
November 26th 04 08:56 AM
by Bob Phillips Go to last post
2 1,632
This one is tricky....Macro to save file as cell value x in di by Andy
Thankyou very much for your help this worked well... "JE McGimpsey" wrote: > This is rather an FAQ if you look in the archives: > > ...
November 26th 04 08:52 AM
by Bob Phillips Go to last post
4 1,660
How to count matching text by Duplicateman
Let's say you have a list of hundreds of confirmation numbers, they can be text, numeric or alpa-numeric, how can I know how many of the entries are exact...
November 26th 04 08:40 AM
by Max Go to last post
6 1,269
Cells losing formatting by BdgBill
This is driving me nuts! I use excel 2000. From time to time certain cells (usually blocks of cells or an entire row) containing numerical data lose all...
November 26th 04 08:03 AM
by Nick Hodge Go to last post
1 1,441
Understanding .End(xlUp) (1,1) by Dennis
Using XL 2003 & 97 Apparently, I just do not get it. I wish to enter "Test" into the first empty cell in Column A. Tried .Value and .FormulaR1C1 to no...
November 26th 04 02:50 AM
by Alan Beban Go to last post
3 7,141
empty cells in ranges by UniDave
I am building a macro which will populate a range but I need to know how to goto the next empty cell in that range Any suggestions, good...
November 26th 04 02:18 AM
by Norman Jones Go to last post
2 1,039
Message box ? by Db1712
How do you get multiply lines of text with in a message box? formatting as line 1 "text " line 2 "text " etc -- Db1712
November 26th 04 02:04 AM
by Chip Pearson Go to last post
1 855
Excel and Powerpoint by freekrill
Hi all, This is really a powerpoint question, but maybe someone here knows the answer or can point me in the right direction. I have an excel page linked to a...
November 26th 04 01:50 AM
by freekrill Go to last post
0 1,411
Open a file in excel from a link in eplorer by Dave Peterson
Saved from a previous post: There's a setting in Windows that you can change. In win98, I can do this: Start Windows Explorer View|Folder Options File Types...
November 26th 04 01:25 AM
by Dave Peterson Go to last post
0 2,369
Status Bar - Key Board Short Cut by excel_googler
If we right click on Status Bar ( Near Caps, Num, Scroll indicators ) we can Sum, count, Find average etc. . of Cells blocked. Is there a keyboard short cut...
November 26th 04 12:58 AM
by Chip Pearson Go to last post
1 1,758
Microsoft Templates by John Stauffer
When I attempt to download a Excel template from Microsoft's template area, I receive the following error: Excel.exe has generated errors and will be closed...
November 26th 04 12:46 AM
by excel_googler Go to last post
1 1,661
Excel Expression by Yubasus
Hello, I have an expression that goes like this =IF(B24>1,0,CEILING(B24,-5000))*(-1). This expression is giving me a zero value if B24 is greater then 1. I...
November 26th 04 12:41 AM
by Yubasus Go to last post
2 1,556
Time Stamp-With Change by AntonyY
I seen many posts on in this forum on time stamps. My problem this that in a1:a10 are going to be the entries. I need upon each entry into each cell a time...
November 25th 04 11:38 PM
by Gord Dibben Go to last post
1 1,881
using the same name reference in multiple worksheets by ericx
Hi all, Dumb question, but I can't seem to get it to work... 2 spreadsheets ... In spreadsheet 1 (Year 2001), in formulas within that spreadsheet I refer...
November 25th 04 11:32 PM
by Bob Phillips Go to last post
3 1,843
Footers by Antonio
Hi Have a footer, 7 diferent lines and diferent lenght. Is there anyway (VBA) to get the lines Justified so that they, when printed have the same...
November 25th 04 11:19 PM
by Antonio Go to last post
0 1,519
Address returned, Not Contents? by MJSlattery
Hi! I am trying to paste an image into a cell who's address is calculated by the following: =IF(C32=1,MAIN!B2,...
November 25th 04 11:11 PM
by MJSlattery Go to last post
0 1,579
How do I extract cells from multiple workbooks by Trevor
I am trying to extract the same cells references from multiple workbooks. All the wokrbooks are identical apart from the information stored. I want to be able...
November 25th 04 10:59 PM
by Ron de Bruin Go to last post
1 2,445
Creating a Date Selector in Excel VBA? by Mark
check out my calendars at: http://au.geocities.com/windsofmark However, if you want an Excel-based Calendar and schedule list, then send the info to me and...
November 25th 04 10:59 PM
by Mark Go to last post
0 3,209
copy\paste from one workbook to another by Mark
Hi, i don't use copy and paste. if you assign a string to the source cell then the value is stored in the string. While the macro is still alive, the workbook...
November 25th 04 10:55 PM
by Mark Go to last post
0 1,979
Error Message appearing when saving a file by JaneC
I have the following message appear when I save one of my files: “Excel could not save all the data and formatting you reently added to ‘File Name’. To...
November 25th 04 10:35 PM
by JaneC Go to last post
0 1,839
Post New Thread

Display Options
Showing threads 146421 to 146440 of 146447
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.