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
Checkbox Quandry by [email protected]
I have a spreadsheet with a number of non-contiguous checkboxes (forms control) in column A. Section headings break up the sequence. In column B, there is a...
(Multi-page thread 1 2)
13 627
Temporarily Suppressing the Printing of Page Footers by Tim Childs[_10_]
Hi I am creating a formal document (annual accounts) in Excel and while working on the Excel file want the page footers to print but need to be able to...
June 11th 16 07:59 PM
by GS[_6_] Go to last post
3 701
Key press alternative for Ctrl+Break by BlueDice
Greetings everyone For keyboards without the Break key I know that there are a number of alternatives depending upon which pc you look at. I am contemplating...
June 10th 16 11:13 PM
by GS[_6_] Go to last post
3 504
Excel Add-ins for 2010 by [email protected]
How do I download the Power Query add-in for my 2010 versin of excel. I've gone to the Microsoft Download Centre and clicked on DOWNLOAD - 32 BIT, then next...
1 449
Convert Number to Words (Indian Format) by Tilak Minocha
How to convert numbers into words in Microsoft excel for example to convert 1,23,123.56 into "Rupees one lac twenty thre thousand one hundred twenty three and...
June 10th 16 01:06 AM
by Auric__ Go to last post
5 574
My code stops working by [email protected]
I have the follwoing code in Sheet1. Using it, I can hide og show specific sheets by putting x'es in cells A1 to H1. It woeks nicely, but if I rename just one...
June 9th 16 07:34 PM
by GS[_6_] Go to last post
7 548
Modify Code to loop back through table after its been updated and process it by TimLeonard
I have been looking for a way to expand the following code to update some attribute block values (Tagstrings) after modifying the spreadsheet but with no...
(Multi-page thread 1 2)
June 9th 16 03:45 AM
by TimLeonard Go to last post
11 973
Critique my filter/copy/visiblecells code... by L. Howard
This works pretty good, but seems to me to not be the "proper" use of .VisibleCells. Where the code looks at all sheets in the array, column E, if the value...
June 8th 16 09:55 AM
by L. Howard Go to last post
5 548
Memory Overflow issue (clear worksheet that has Worksheet_Change action) by Phrank
Hi, I've got an overflow error that I don't know how to deal with. High level: I'm clearing all contents and formats from a sheet, and then copying/pasting...
June 7th 16 11:39 PM
by GS[_6_] Go to last post
8 545
Automatically (w/o macro or vb) dynamically mirror one excel tableonto another by pete
I have two excel tables in an excel workbook, on two separate tabs: TableA and TableB. TableA is a legacy table, which has 8 columns. Upon the workbook...
June 7th 16 01:07 AM
by pete Go to last post
0 432
A tale of two tables by pete
Hi, I have two excel tables in an excel workbook, on two separate tabs: TableA and TableB. TableA is a legacy table, which has 8 columns. Upon the...
June 6th 16 11:29 PM
by pete Go to last post
0 461
Conditional Formatting by steve
Hi, I just wondered if anyone knew if it was possible to copy and paste a cells conditional formatting result with the actual formula that it was based upon....
June 6th 16 09:00 PM
by Claus Busch Go to last post
1 461
Exit when Cancel clicked. by [email protected]
Hi All I have the code below which places user's inputs into the last-used cell in column C. At present, if "Cancel" is clicked a blank row is added. I would...
6 447
MID and FIND function in vba by L. Howard
With a list of state/city in column A. Wyoming - Greybull Indiana - South Bend Illinois - Itasca Texas - Mineral Wells Wyoming - Powell Wyoming - Cody Texas -...
(Multi-page thread 1 2)
June 5th 16 12:08 PM
by GS[_6_] Go to last post
17 778
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 454
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 400
[ 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 432
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 383
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 642
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 971
Post New Thread


Display Options
Showing threads 141 to 160 of 174009
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:34 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.