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
Pivot wrt active sheet & current region by ANG
Range("A1").Select Sheets.Add ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "wr!R1C1:R638C31",...
June 21st 16 06:28 AM
by Claus Busch Go to last post
1 192
HLookup/Needing Formula Question by Munster
Sheet 1 A B C D 1 Location Item Qty. Lot# 2 001a Apples 23 5998 3 002a ...
June 21st 16 05:53 AM
by Claus Busch Go to last post
3 226
using formula - extract text separated by 2 spaces by ANG
Would be great if someone could give me a formula which would separate text between 2 spaces e.g 10001031 BISCUIT TUC NATURE 100G Ea BEACH SHOP -6 ...
(Multi-page thread 1 2 3)
June 19th 16 08:57 PM
by ANG Go to last post
21 589
Putting Focus into Textbox by jlclyde[_2_]
I have a userform that I am using a barcode scanner to populate a text box. When the form loads the cursor is in the barcode textbox. On change event it does...
(Multi-page thread 1 2)
June 18th 16 02:01 AM
by Mike S[_5_] Go to last post
10 433
.SpecialCells(xlCellTypeBlanks).Delete without going to the sheet by L. Howard
The whole macro is below, which does what I want. It is in a standard module and will be run from any of about 8 to 10 different worksheets. This snippet...
June 17th 16 05:20 PM
by L. Howard Go to last post
9 271
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 513
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 589
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 404
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 352
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 486
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 436
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 829
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 433
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 460
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 348
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 373
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 382
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 359
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 638
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 368
Post New Thread

Display Options
Showing threads 121 to 140 of 173994
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 01:43 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.