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
Find/Replace MSWord wildcard characters from within Excel by Susan
Excel 2003, Windows XP This code, based in an Excel workbook, retrieves words from Microsoft Word (Word 2003). But first it strips out all punctuation. I'm...
September 14th 13 08:06 AM
by GS[_2_] Go to last post
6 480
Open to modify by kardifflad
I'm hoping this is an easy one for someone. I have a macro that writes data to an archive sheet every time a button is pressed. This works fine. However I now...
September 13th 13 11:53 PM
by GS[_2_] Go to last post
3 264
SQL not importing records from ACCDB by Steven North[_2_]
I'm struggling trying to figure out why the SQL is constantly returning 'no records'. It's essentially the same as MS Query. Except in the MS Query it's...
September 13th 13 03:26 AM
by Steven North[_2_] Go to last post
2 302
this action will cancel a pending refresh data command by Emma Hope
Hi All, Hope you can help. I have a number of workbooks with large numbers of sheets with MS Queries to Access databases each also have a number of sheets...
2 1,416
SQL data from VBA - Sort into groups via heading. by [email protected]
Hi Everyone... I am trying to figure out how to go about doing this. I want to build an Excel Finance Reporting Template that will import GL transactions...
September 11th 13 07:35 AM
by GS[_2_] Go to last post
7 417
macro find and delete duplicates in a spread sheet. by Marc[_18_]
Hi, Does anyone know, or point me in the right direction, how to have Excel find duplicate cells and delete them. For example, I have 2 columns of numbers. ...
September 9th 13 09:28 PM
by GS[_2_] Go to last post
5 311
Similar Book to Book Code, one works other does not by Howard
Thanks to Claus for these two codes. Normally you would have the "Copy WkBook To" open and both codes work well. I added the open "Copy WkBook To" code line...
(Multi-page thread 1 2)
September 9th 13 02:01 PM
by Howard Go to last post
11 465
Select Case code error by Howard
This errors out as "Case without Select Case" on the Case Is = "Beef". I first wrote the code for Swine only, just one case and it worked fine. I added the...
September 7th 13 11:49 AM
by Claus Busch Go to last post
8 424
Xpose twenty rows then the next twent etc. by Howard
Want to xpose a list of items in A to cells in B twenty at a time then the next twentyin B below the first etc. Thanks, Howard Option Explicit Sub...
September 5th 13 07:33 AM
by Howard Go to last post
8 340
Checking if a workbook is open by kardifflad
Hi. I have this bit of code that is meant to check if a certain workbook is open and if it is its meant to tell the user to try again later. Unortunately it...
September 3rd 13 05:06 PM
by GS[_2_] Go to last post
8 424
If value in a colum the same concatenate another colume by [email protected]
Hi This is tricky to explain so I will show the output I want below, basically if the same unique value is in one column I would like to concatenate values...
4 515
Run Macro on All Sheets Q by [email protected]
I have a macro that runs a routine on the active sheet, but how would I create a macro that will run this macro on 'all' sheets expect sheet1 & sheet4? I...
August 31st 13 07:29 PM
by GS[_2_] Go to last post
8 5,215
Resize a row but copy but skip columns I don't want to copy by Howard
With the resize in this segment of code, it copies col A and B. On that same row I want to also copy col D and F. So the resize would be c.Offset(0,...
August 30th 13 02:30 PM
by Claus Busch Go to last post
6 377
IF argument limit - how convert formula to VBA? by numbermonkey
I have hit the limit with IF statements in a formula I have in questionnaire I creted in Excel 2010. How would I create this formula in VBA? "TRUE" is...
August 30th 13 07:00 AM
by Harald Staff[_8_] Go to last post
2 304
VBA Help with Form by numbermonkey
Iím advanced at formulas and functions, charts, etc, but NOT very knowledgeable on VBA, so I would greatly appreciate your help on a form (questionnaire) with...
August 29th 13 08:25 PM
by GS[_2_] Go to last post
1 283
If cancel list box don't enter FALSE in list by Howard
This works okay, except if you cancel out of entering something in the list, it enters FALSE. Don't want that. Thanks, Howard Option Explicit Private Sub...
August 28th 13 04:59 PM
by Howard Go to last post
2 270
"Macros are corrupted and have been deleted" message by BW
When I open a workbook (in Excel 2007) that contains a macro, I get the following message every time: The Visual Basic for Applications (VBA) macros in this...
8 632
Code copies between key word is in reverse order by Howard
I dug this out of my archives, modified it slightly for a Poster. Using XX and XXX as "key words" multiple times in column A, it does pretty well. Grabs the...
August 27th 13 10:26 AM
by Howard Go to last post
5 329
Click on button using VBA by [email protected]
Guys i need to Click on web page button using Excel Macro. the source is as follows <button type="button" class="button"...
August 26th 13 06:20 PM
by GS[_2_] Go to last post
6 506
Runtime error 424 in Windows 8 environment by [email protected]
I have downloaded a workbook with some macros from an insurance company. It runs perfectly well on both Excel 2007 and 2010 on a Windows 7 platform, but when I...
(Multi-page thread 1 2)
August 26th 13 09:10 AM
by GS[_2_] Go to last post
15 770
Post New Thread


Display Options
Showing threads 1001 to 1020 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:46 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.