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 Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Even larger fonts by Robert Crandal[_3_]
In Microsoft Excel (or Word) the maximum font size is 72 points (or pixels). Is it possible to force the Office programs to use even larger fonts?
April 16th 16 10:02 AM
by Robert Crandal[_3_] Go to last post
4 697
Getting #Value error on Sumproduct with non-contiguous cells by AJ Master
I'm trying sumproduct, where one of the arrays is...
1 1,001
Logical based Horizontal Lookup by [email protected]
Hello, Have a bit of an odd but challenging request for the group here! The objective for this project is to take a details work schedule which shows tasks...
(Multi-page thread 1 2 3)
April 12th 16 01:18 PM
by Claus Busch Go to last post
28 2,634
Is it possible to copy vba macros into a workbook using a vba macroto do the copying by Desmond Walsh
I have a series of workbooks one for each year handling budgetary data that prepares tax information for the year in question. If I modify a macro or add a...
April 11th 16 11:26 PM
by GS[_6_] Go to last post
6 738
activeworkbook connections.delete not working by bobh
Hi All, Hopefully I explain this well......... I have a Excel 2007 spreadsheet which has a data connection to an Access 2007 table. In VB I do a Run Macro1...
April 11th 16 06:03 PM
by bobh Go to last post
0 462
Working from data converted from a pdf file by B Roberson
040480-00 HOLLON #26-1@ OK WOODWARD 09/15 G 1562 1.22 2.49 3,895.79 3,649.51 1.0000000 WI 3,895.79 3,173.26 TOKER -3.42...
(Multi-page thread 1 2 3)
April 6th 16 10:38 PM
by GS[_6_] Go to last post
26 1,148
Can't find project or library by hbj
I had to change my computer and therefor reinstall Office 2007. I have an Excel project I am unable to run now due to the message above. Often the macro stops...
(Multi-page thread 1 2)
April 6th 16 11:50 AM
by Peter T[_7_] Go to last post
16 886
Copy sheet name to same cell on each sheet, 50 sheets; run code onany worhseet beforedoubleclick by Mike S[_5_]
I'm using Excel 2000 (yes ancient, I know). I have a workbook with about 50 worksheets, I would like to copy the name of each worksheet to the A5 cell of...
April 5th 16 06:51 AM
by Mike S[_5_] Go to last post
3 529
Question
VBA assistance needed, Grouping and Tables by Coyoteman
I'm brand new to Macros, so bear with me. I have a workbook that will have some protected and unprotected sheets. One sheet is in a table format, where columns...
April 4th 16 11:53 PM
by GS[_6_] Go to last post
2 464
Upload an image depending on the value of cells by luis vejarano
good days' group I would like to help me in this VBA script of Excel. I have this code is not mine, I found diving from the network, is free is not...
April 3rd 16 05:11 PM
by luis vejarano Go to last post
2 428
Determine closest control to MouseUp event? by Auric__
Is there an easy, accurate method to determine the closest control to a MouseUp (or MouseDown, if it's easier) event, if the user clicks on the UserForm...
April 3rd 16 05:08 PM
by Peter T[_7_] Go to last post
8 493
Macros not enabled by L. Howard
I run this macro in my workbook and it lists all my Excel workbooks I keep in archive Documents folder. Sub GetFileNames() Dim xRow As Long Dim xDirect$,...
April 3rd 16 02:08 AM
by L. Howard Go to last post
2 458
Formatting date as first letter of day only by GavinS
In various cells I have dates written in as dd/mm/yy format. I would like to format this as d - that is the first of the day only. For example 16/12/10...
(Multi-page thread 1 2 3 ... Last Page)
34 2,966
VBA error 1004 on With worksheet.Paste by AJ Master
I have a worksheet with data that I sometimes want to copy to 3 other worksheets rather than entering the data on each sheet individually. I just recently...
March 31st 16 07:30 PM
by GS[_6_] Go to last post
4 589
Deleting rows from a structured table based on the value of a column by [email protected][_2_]
I'm using the code below to delete rows from a structured table based on a column having a zero value. In the table I have there are 6 rows with a zero value...
2 472
F1 help in VBA environment opens sheet; send VBA to background. Howto stop? by [email protected]
Pressing F1 on a highlighted keyword in the VBA code editor now brings me directly to the proper uS online document. But at the same time, Excel opens the...
0 997
Trouble Counting how many times a Cell Value Occurs when Condition isin a Row and not a Column by Munster
Here's an example of the issue I am running to A B C D 1 GolfA Birdie Par Bogey 2 GolfB ...
March 26th 16 07:37 PM
by MM[_5_] Go to last post
2 400
Hyperlink usage by Walter Briscoe
I wish to count bus stop usage in London. Sheet1 has about 1000 rows. Each row has up to 2 hyperlinks elsewhere to information on the stops in a particular...
March 19th 16 08:51 AM
by Walter Briscoe Go to last post
7 694
Copying down conditional formatting alone by Walter Briscoe
I have some Excel 2003 documents. All cells have 3 Conditional Formatting rules. The same Conditional Formatting rules apply to all cells. Each rule is a...
March 17th 16 09:37 PM
by Walter Briscoe Go to last post
2 453
Remove unicode characters from cell containing values by [email protected]
Pls assist with macro how to remove invisible unicode characters in a cell Thxs A
March 13th 16 03:44 AM
by GS[_6_] Go to last post
6 534
Post New Thread


Display Options
Showing threads 201 to 220 of 174032
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 02:47 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.