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
Help with xPath - SearchNodes not returning any nodes by Gary Page
Hi, I'm trying to write a macro that determines which worksheet corresponds to which file in xl/worksheets. I found an example on the web, but the SelectNodes...
September 16th 16 12:52 AM
by GS[_6_] Go to last post
1 417
! exclamation point as pointer to active sheet with R1C1 reference by arcibald tuttle
I'm using R1C1 with most of my macro writing but occasionally I have trouble when I want to make sure the reference refers to the active sheet, not to the...
September 3rd 16 03:38 PM
by arcibald tuttle Go to last post
0 486
Using very hidden macros (plus other macros) on a shared file by [email protected]
Hi all I am trying to produce a shared workbook for the weekly payroll, which needs to be accessed by various units, but for them to only have access to the...
September 2nd 16 08:44 PM
by GS[_6_] Go to last post
1 335
Import Module weirdness by Ray
Hi - I've created a "patch" tool to update a complex workbook used by approx 50 people. Among many other things, the patch updates several macros (using Chip...
September 2nd 16 05:31 PM
by Ray Go to last post
5 324
VBA Code to find the Row Number of the last repeated row of aparticular date field by shriil
I have this Table where the first field is a Date Field where the dates are repeated. Column A 1 14-Aug-2016 2 14-Aug-2016 3 ...
September 2nd 16 12:49 PM
by shriil Go to last post
2 337
for next with if by [email protected]
Hi, I would like to filter out blanks in column L on every worksheet except for the one called "Revisions", not sure why this doesn't work: Sub...
3 310
vba code to send a filename to word without starting a new session by [email protected]
Hello, I got pretty far with my vba project but got stuck now. What I have so far: I have 2 monitors, on the left an excel sheet with filenames and on the...
August 30th 16 11:47 PM
by GS[_6_] Go to last post
3 323
Transfer data from one workbook to another workbook resident inNetwork, based on Date Filters by shriil
Hi I have a workbook RawData.xlsx in my D: Drive, containing a worksheet "Data" which gets populated date-wise basis. It is quite a large datasheet as it...
August 30th 16 02:55 AM
by shriil Go to last post
2 307
record counter based on column value by Sabosis
This should be an easy one... In column A I want to have a counter or series that only changes to the next value when the value in a separate column...
August 26th 16 07:12 PM
by GS[_6_] Go to last post
3 335
ColorIndex count function by L. Howard
I thought I could alter any number of function examples that count the cells in a range for either the Font color or the Cell.Interior.ColorIndex or both. I...
August 24th 16 11:58 AM
by L. Howard Go to last post
4 312
Inserting Rows based on cell differences and interpolating in between by [email protected]
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 573
Converting Excel Formula Arrays to Dynamic VB Array Code Help by [email protected]
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 418
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 372
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 357
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 344
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 287
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 311
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 891
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 320
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 308
Post New Thread


Display Options
Showing threads 121 to 140 of 174032
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 10:31 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.