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
Copy a by macro special selected nr of rows into another file by jmslab@xs4all.nl
As part of a complex process of actions, there is a new part where I can use some help. I think it's easy if you knows the correct code :) (as...
October 10th 16 08:48 PM
by jmslab@xs4all.nl Go to last post
7 248
Camera picture resolution or sharpness by Scott Riddle[_2_]
I used the camera icon to make a preview window/picture of a range of cells.. In that range I am creating a label basically. I then use the camera icon to take...
(Multi-page thread 1 2)
October 9th 16 05:29 AM
by Mike S[_5_] Go to last post
11 363
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 194
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 277
Save Excel VBA as tab delimited text file without quotes by kakisami14@gmail.com
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 245
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 237
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 268
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 208
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 367
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,175
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 327
! 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 374
Using very hidden macros (plus other macros) on a shared file by richardnadin7@googlemail.com
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 263
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 250
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 270
for next with if by kijijijt@gmail.com
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...
September 1st 16 06:28 PM
by kijijijt@gmail.com Go to last post
3 240
vba code to send a filename to word without starting a new session by info@ecsystems.nl
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 260
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 228
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 275
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 251
Post New Thread

Display Options
Showing threads 81 to 100 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:45 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.