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
Hotkey in proper workbook by Charlotte E.[_3_]
I have a workbook containing a macro, which is activated by a hothey combination (CTRL + SHIFT + N). This hotkey combination is created with...
July 18th 12 03:48 PM
by Charlotte E.[_3_] Go to last post
2 349
Iterating through each label on a worksheet by [email protected]
I need to write something that will iterate through all of the labels on my worksheet and change some of their properties. Specifically, I need to update the...
0 338
1 Attachment(s) Macro to search for a value and insert new row by ksquirt
I need a line in a macro to search column D, find value '90601' and copy the row that has that value in column to a new row and change '90601' to another...
July 17th 12 03:11 PM
by ksquirt Go to last post
3 974
import text by [email protected]
I was given this code, which extracts lines of text from a range of selected text files. At the time I thought I only wanted one line to be extracted per file...
1 397
Using =Offset in Charts by [email protected]
I'm trying to update a chart so that it will handle different ranges fluidly. I've read quite a few different articles on setting up a data series that...
1 400
Easy code, confounded by error by [email protected]
I'm simply trying to get the text stored in a cell that has its own named range. I keep getting a "Method 'Range' of 'object _Global' failed" error. Here is...
3 400
alternate rowshading using conditional format excel 2007/2010 by Ludo
Hi, I'm using following code on a Excel 2003 version without problems to change the row shading. Formula comes from John Walkenbachs site...
July 16th 12 05:10 PM
by Ludo Go to last post
6 839
using xltm as template by Andrew[_56_]
Hello, This is not really a programming question, although I'm sure someone in this forum can help. I write a lot of excel programs/macros in templates. When...
July 15th 12 05:28 PM
by Andrew[_56_] Go to last post
2 403
VBA Coding Trick by sam99
Hi, I want to know if there is any trick or tip to make my code looks complicated or hard to understand or a way to re-write or add to the code more lines so...
July 15th 12 02:48 PM
by sam99 Go to last post
5 576
Lock Row (A~F) based on criteria in g by nhkhurum
I have lot of data in sheet 1 (for whole years) I want to lock cell from A~F when in cell G i give some criteria Like Posted. Whole the sheet remain...
July 14th 12 07:00 PM
by Auric__ Go to last post
1 352
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria by skitsoni
Hello all, I have a fairly simple code below that's missing one critical step. Currently, it wants to copy the data to the first blank column it finds in the...
July 14th 12 11:25 AM
by Sepeteus Jedermann Go to last post
1 586
Save record Into master sheet! by [email protected]
Hi, I want to consolidate data from 10 different sheets into one sheet. One option i have done is i have merged all the data from 10 sheets into master sheet....
July 14th 12 04:06 AM
by Auric__ Go to last post
1 385
How to retrieve number of visible digits after decimal point in VBA by N Lee[_2_]
Greetings: Not sure if there's a way to do it, but someone might have a good idea. I want to retrieve the number of visible decimals in a cell as an...
July 13th 12 09:45 PM
by Ron Rosenfeld[_2_] Go to last post
8 2,360
use content of a cell as an input for a google query and return the URL of the 1st re by bobv
use content of a cell as an input for a google query and return the URL of the 1st result: I am looking for an automated solution that will use the content of...
July 13th 12 07:51 PM
by bobv Go to last post
0 357
Need to auto-enter last updated date, only if another cell has changed by D4WNO
Hi all, I hope you can help - I know how to auto-update a field with today's date when saving a file, but I need to instead enter today's date only when the...
July 13th 12 02:49 PM
by Claus Busch Go to last post
1 410
Defining public/global variables in more than one place by stainless[_2_]
Using Excel 2003 (hopefully will persuade my company to allow us to upgrade our excel reports to 2010 at some point!) I am trying to standardise the code in...
July 13th 12 10:44 AM
by Peter T[_5_] Go to last post
2 330
Search macro for greater than 100000 on multiple CSV files by Dirkmiller
Hi, i am trying to create a macro, which will run through a folder of different csv files and search for values of 100000 and then copy the entire row into a...
July 13th 12 08:31 AM
by Auric__ Go to last post
1 438
Excel 2010 Pivot Table by carl
I ran into an issue while using the Pivot Table. My data looks like this: Code RejectReason AP No Quote AP No Quote AP No Quote AP No Quote AP No Quote
2 517
closing another file by code causes failure to run workbook activate event by [email protected]
I have a userform in workbook A that opens workbook B and hides the userform. File B has a button to "return to the userform (workbook A)". All the button...
2 449
VBA to find largest total of ANY two values by H3dgehog
Good morning, I have a list of percentage values in a column (totalling 100%). I have to run 3 specific tests against this data set: 1) Find the highest sum...
July 12th 12 01:01 PM
by H3dgehog Go to last post
0 290
Post New Thread

Display Options
Showing threads 2001 to 2020 of 174008
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 05:28 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.