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
Macro for Show/Hide Column by Andy
worked well. chose this one. "tjtjjtjt" wrote: > Here's a basic macro that will do it: > > Sub HideColD() > Columns("D:D").Select > If...
November 26th 04 01:03 PM
by Don Guillett Go to last post
2 3,023
background formatting across multiple cells by Casper
Hi I am looking to do a 2 colour fill effect similar to that achievable on charts across multiple cells...is this possible? Basically I want to fill the cells...
November 26th 04 11:18 AM
by Casper Go to last post
0 1,588
Re-assigning weekend days in "Networkdays" Function by sts75
Thanks my friend, it worked :) -- sts75 ------------------------------------------------------------------------ sts75's Profile:...
November 26th 04 10:45 AM
by sts75 Go to last post
0 1,072
Time Stamp without change by AntonyY
I've got a speadsheet that will need a time stamp. The entries will be going into A1:A10 and in B1:10 will be the time stamp. But all the time stamps that I...
November 26th 04 09:13 AM
by Harald Staff Go to last post
3 1,226
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,662
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,707
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,315
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,499
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,189
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,064
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 884
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,447
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,424
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,795
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,690
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,599
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,928
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,879
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,558
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,614
Post New Thread


Display Options
Showing threads 146421 to 146440 of 146451
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 10:36 PM.


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