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
Loop through a filtered range and copy unique values to a second sheet by Phrank
Hi again, Accidentally hit the Send Now button before I had the question written. Sorry about that. I've got two sheets with values in columns E and A,...
June 4th 16 01:08 PM
by Phrank Go to last post
2 371
Loop thru filtered sheet, copy unique values to another sheet by Phrank
Hi, Sub Macro5() ' Dim nameRange As Range Dim wksQB As Worksheet Dim wksMDR As Worksheet Dim var As Variant Dim cell As Range
June 4th 16 12:58 AM
by Phrank Go to last post
0 320
[ NEED HELP ] Loop in VBA by FOONG KAH LOON
Hi all, I'm totally new into VBA. I need to Loop a task from row to row ( about 99 rows). I get some sample Loop coding from the internet and however it seem...
May 29th 16 05:55 AM
by Claus Busch Go to last post
1 361
Run time error '49': Bad DLL calling convention - solved by Walter Briscoe
I run Windows Vista, Excel 2003 and code in ...\XLSTART\PERSONAL.XLS. Some days ago, I hit this error. I solved it by Export File in the Visual Basic Editor,...
May 28th 16 07:08 AM
by Walter Briscoe Go to last post
0 303
dynamically change IF formula in macro, possible? by Mike S[_5_]
I'm trying to calculate percentages that a column of values are of a single cell value, e.g. column a contains values 10 through 100 column b will contain the...
May 25th 16 05:03 PM
by GS[_6_] Go to last post
2 533
populate =IF(... dynamically in loop, possible? by Mike S[_5_]
I'm trying to calculate percentages that a column of values are of a single cell value, e.g. column a contains values 10 through 100 column b will contain the...
(Multi-page thread 1 2)
May 24th 16 12:43 PM
by Mike S[_5_] Go to last post
12 837
Need to get a Page Number for a Cell by Chris Scott
I have a large worksheet that I had been merging cells based if they contain the same information. The problem is, the document could be super long and I am...
May 11th 16 07:05 PM
by Claus Busch Go to last post
3 499
Better protection for VBA project? by Ron[_32_]
Hi All, (I'm not a VBA pro, more of an enhusiastic amateur) Is it possible to better protect a VBA project? I wrote a simple trading sheet for a guy...
(Multi-page thread 1 2 3 ... Last Page)
30 2,945
VBA Programming by Gaurav[_9_]
Need to groom my VBA programming skills. Please guide me. Pls suggest me the Books, Websites, Any group, etc.
May 9th 16 06:18 AM
by G C Go to last post
5 530
Need help in creating sum macro by [email protected]
Hi, I need to create Macro of addition for example. Data is available in Column C4 to c34. The answer should display at C35. Can anyone help me out? I am...
May 7th 16 09:20 AM
by Claus Busch Go to last post
1 344
Sub or Function not defined - Call to a sub in and XLAM addin by hbj
Have to admit: I don't quite understand XLA:s and their use. I have made an XLAM file with common UDFs: and Subs. In the developer mode, this XLAM is loaded...
May 6th 16 04:43 PM
by hbj Go to last post
1 470
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 417
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,531
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 543
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 428
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 502
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 537
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 513
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 505
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 513
Post New Thread


Display Options
Showing threads 141 to 160 of 173995
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 11:12 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.