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 different value from duplicate selection - macro help by Miss
I am writing to seek help in updating the following code below, so the macro function allows me to look through data which have duplicate name values (from...
October 4th 16 11:23 AM
by Miss Go to last post
0 282
please help in VBA or Formula by TheExpat Wanderer
https://groups.google.com/forum/#!topic/excel-macros/UHeKbdHFJN4 in the attached excel file .
October 2nd 16 12:21 AM
by Auric__ Go to last post
1 388
Save Excel VBA as tab delimited text file without quotes by [email protected]
Today I use this code to save my sheet as a tab delimited text file: ActiveWorkbook.SaveAs ActiveWorkbook.path & "\" & filnamn, FileFormat:=xlText It works...
September 29th 16 05:03 PM
by GS[_6_] Go to last post
2 369
subroutine stops running unexpectedly by Matthew Dyer
I have no clue as to why this is occurring, but when trying to write subroutines and macros and whatnot, my sub stops running when trying to perform some type...
September 28th 16 08:09 PM
by Bạch11165 Go to last post
6 338
find different value from duplicate data - macro help by Miss
I am writing to request macro (VBA function), which allows to me to see different data value (from column K and L from duplicate rows of data. For example...
September 28th 16 09:18 AM
by Txlebang106 Go to last post
4 406
tracking table data by TheExpat Wanderer
Product # colour stage time 111 red s1 12:00:00 AM 222 white s2 1:00:00 AM 333 blue s1 2:00:00 AM 444 red s3 3:00:00 AM 555 red s4 4:00:00...
September 27th 16 01:24 PM
by Adrian Caspersz Go to last post
1 303
loop ends unexpectedly before finishing loop by Matthew Dyer
Sub MoveDone() Dim i As Integer, ii As Integer Worksheets("CIT291").Activate For i = LastRow(ActiveSheet) To 2 Step -1 With Range("a" & i) If...
September 23rd 16 06:13 PM
by Matthew Dyer Go to last post
7 501
Read (and parse) file on the web by Auric__
Robert Baer wrote: > Excel macros are SO... undocumented. Sure they are. Plenty of documentation for individual keywords. You're not looking for that,...
(Multi-page thread 1 2 3 ... Last Page)
September 20th 16 09:20 AM
by Robert Baer Go to last post
87 2,940
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 464
! 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 556
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 371
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 360
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 365
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 344
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 367
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 332
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 364
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 329
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 626
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 454
Post New Thread


Display Options
Showing threads 121 to 140 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 02:08 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.