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
VBA assistance needed by G C
I have to reconcile my multiple bank account transactions with my system's compiled transactions and need the unique system id against that account no. I've...
May 6th 16 02:19 PM
by Claus Busch Go to last post
7 614
data validation using VBA, best practice? by Mike S[_5_]
I have 11 columns of data I want to validate before printing a report. The plan is to write VBA code to do validate cell contents in loops. In this case I...
April 26th 16 02:17 AM
by Mike S[_5_] Go to last post
4 1,888
req. for ideas for numeric worksheet by Mike S[_5_]
I have a tax worksheet that is being used to show the assessed tax on housing units for '12-'15, including any amount paid for each of those years. Right now...
April 23rd 16 11:32 PM
by GS[_6_] Go to last post
9 805
VBA: Can I Use Named Columns for Sorting? by David Godinger[_2_]
Is it possible to do the following in Excel 2003? 1) Name columns so they can be referred to in VBA 2) Write VBA for sorting with named columns instead of...
April 21st 16 06:54 AM
by David Godinger[_2_] Go to last post
0 589
Set value from comparison of other cell values? by David
I've just hit a minor problem with Excel - or should I say with my understanding. I'm trying to set up a spread sheet to calculate tax rules which are...
April 20th 16 03:00 PM
by David Go to last post
2 706
Convert a Find/Loop to an Array macro by L. Howard
This works but is too slow as you would expect. Fine for the two dozen +/- rows I am testing on. Tried the ole Array caper but far as I could get was writing...
April 17th 16 01:12 PM
by L. Howard Go to last post
8 752
Embed drawing toolbar textbox or word doc in sheet, how to refer toit? by Mike S[_5_]
I need to generate a report that will work in Excel 2000 and later, I'd like to embed a rich textbox control (with scrollbars), or a Word document if that...
April 17th 16 06:14 AM
by Mike S[_5_] Go to last post
7 734
Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats by Phrank
I have a 'user' workbook to which users can add notes and highlights. Each day, they update their 'user' workbook (target) against the updated data workbook...
April 16th 16 06:32 PM
by Phrank Go to last post
4 758
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 747
Getting #Value error on Sumproduct with non-contiguous cells by AJ Master
I'm trying sumproduct, where one of the arrays is...
1 1,043
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,788
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 789
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 494
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,221
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 948
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 558
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 480
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 446
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 531
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 499
Post New Thread

Display Options
Showing threads 201 to 220 of 174039
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 12:11 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.