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
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 410
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 383
Get data for matching headers thru macro by [email protected]
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 364
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 315
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 331
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 960
Index and Match Help by Munster
August 3rd 16 12:27 PM
by banhtrungthu247 Go to last post
6 352
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 344
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 439
VBA - How to "execute" a dynamic variable assignment by [email protected]
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 531
"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 347
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 337
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 465
Convert Numeric Values in Column to Text via VBA by [email protected]
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...
3 428
Password Cracker for Excel Worksheets/ Workbooks by [email protected]
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,807
Click on Webpage Box by [email protected][_2_]
I have been trying to click on the box labeled "Select Weight & Count" on the following web...
0 373
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 347
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 420
Find and Replace Q by [email protected]
I took the code below from SpreedsheetGuru, but want to tweak it for my specific needs and I am a little lost Code below Finds & Replaces from a Table values...
2 347
Programing to save who and when someone update the file by [email protected]
I'm trying to programing the file to save in the column "R" and "S" the timing and user who updated the file, but this only works for updating in the first...
July 8th 16 06:49 PM
by GS[_6_] Go to last post
4 334
Post New Thread

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