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
Inserting Rows based on cell differences and interpolating in between by wizardgeophysicist@gmail.com
Hello - I have a complicated issue. I have a file with 5 columns (A, B, C, D, E). A is fixed string value. B is a number increasing irregularly. C, D, E,...
(Multi-page thread 1 2)
August 22nd 16 12:30 PM
by GS[_6_] Go to last post
12 473
Converting Excel Formula Arrays to Dynamic VB Array Code Help by andrew_mcnicol@yahoo.co.uk
Hi all, Its been a while since i have been on here so VB getting a little rusty, anyway hoping one of you Guys will be able to use your vast knowledge to help...
August 21st 16 08:56 PM
by GS[_6_] Go to last post
5 342
How to create backups of your workbooks as you open and as you close by Greg Glynn
If you're working on an important workbook and wish to keep a running list with separate incremental backups, you can copy this code to your 'ThisWorkbook'...
August 16th 16 04:21 PM
by Auric__ Go to last post
3 321
Worksheet_Calculate by L. Howard
Range("B8:B37")) are formulas returning strings such as "Cash" or Equities", as two examples, then data is copied to a certain sheet for that string. There...
August 7th 16 04:11 PM
by L. Howard Go to last post
6 313
Get data for matching headers thru macro by iamankolekar@gmail.com
Hi, My name is Praveen, I am working on huge data import and need support on macro. I have a path "C:\Users\ankopr01\Documents\My Received Files" in which 300...
August 6th 16 05:31 PM
by banhtrungthu58 Go to last post
4 294
a twist on counting unique values in a range which contains blankcells, using a formula. the formula can't use SUMPRODUCT or FREQUENCY by pete
I need a formula, not VB code, to count the number of unique values in a column of up to 10,000 rows, some of which will be blank. The values may be numeric,...
August 4th 16 09:17 PM
by pete Go to last post
5 246
Capture # of Button pressed to pass to another form by jlclyde[_2_]
Hello, I have a form that has six buttons on it. I have another form that I would like to capture the button that was pressed. For instance if Bt1 is pressed...
August 4th 16 12:36 AM
by banhtrungthu68 Go to last post
4 251
Email on save by Paul Doucette
Is there a way I can set up my spreadsheet to send an email to alert others in my company that it has been updated, every time I save it? Thanks! Paul
(Multi-page thread 1 2 3)
August 4th 16 12:33 AM
by banhtrungthu68 Go to last post
24 736
Index and Match Help by Munster
A B C D E F G 1 PRODUCT PRODUCT DATE CODE LOCATION RESULT 2 APPLES AP16063 3 4 5 6 PRODUCT MFG Product...
August 3rd 16 12:27 PM
by banhtrungthu247 Go to last post
6 264
Error on paste by Paul Doucette
This code has worked in the past for copying an oval shape with a clear background from one sheet to another. (we use it to circle info we wish to draw...
July 27th 16 10:31 PM
by GS[_6_] Go to last post
5 247
ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly by David Godinger[_2_]
I’m using UserInterfaceOnly, so that I can run macros and still keep my sheet protected. I tried to use ActiveCell to calculate only certain ranges, without...
July 27th 16 04:07 AM
by edelkochen Go to last post
5 338
VBA - How to "execute" a dynamic variable assignment by ddmcmath@gmail.com
Cell A1: "MyVar" Cell A2: "Purple" Cell A3: "String" I want to run code that does the following Public MyVar as String MyVar = "Purple"
July 20th 16 05:29 PM
by GS[_6_] Go to last post
7 392
"Continue?" Message Box by Paul Doucette
I have code that runs when a command button is triggered, that does several things, including saving the file. After that command button is triggered, and...
July 18th 16 12:05 AM
by Paul Doucette Go to last post
4 250
Number of records for last 7 days by R D S
Hello, You guys have been very helpful to me in the past. I have a spreadsheet with a column of dates, I would like a textbox on a form display the number...
July 17th 16 09:04 PM
by R D S Go to last post
3 260
Need Macro help to stop repeating some info by ksquirt
I am trying to tweak a macro by adding new rows into the tabs and then add them to the macros for compilation in an email. The issue I have is that the...
July 14th 16 08:48 PM
by ksquirt Go to last post
2 368
Convert Numeric Values in Column to Text via VBA by seanryanie@yahoo.co.uk
Does anyone have some VBA code that will convert all numeric values to text value in a certain column, in a certain worksheet? Eg convert 630 to '630 The...
July 13th 16 03:09 PM
by seanryanie@yahoo.co.uk Go to last post
3 308
Password Cracker for Excel Worksheets/ Workbooks by kthprog@gmail.com
This has been floating around for a while now, but I gave it a serious reworking. Option Explicit Public Sub AllInternalPasswords() On Error Resume Next ' '...
(Multi-page thread 1 2)
July 13th 16 11:32 AM
by Raj[_12_] Go to last post
15 2,454
Click on Webpage Box by oitbso@yahoo.com[_2_]
I have been trying to click on the box labeled "Select Weight & Count" on the following web...
July 11th 16 02:46 AM
by oitbso@yahoo.com[_2_] Go to last post
0 255
data filter via VBA by Paul Doucette
I have a command button that runs code in order to assign a random number and save a workbook. I would like to add a step to this code so that it takes the...
July 11th 16 01:34 AM
by Paul Doucette Go to last post
2 234
Print, Save as PDF, Email PDF code by Paul Doucette
I am looking to assign vba code to a command button which will do the following: 1) Print worksheet “Quote” and worksheet “Sheet1” to my default...
July 10th 16 03:15 PM
by Paul Doucette Go to last post
7 292
Post New Thread


Display Options
Showing threads 101 to 120 of 174006
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 06:47 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.