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
Compare cell contents by GARYWC
A1 and B1 have a text format. A1 contains 2016:08:11 23:50:55 B1 contains 2016:08:07 14:47:31 What formula will determine which cell contains the earliest...
(Multi-page thread 1 2)
October 14th 16 03:58 PM
by Bruno Campanini[_2_] Go to last post
10 449
Colormarking of fields based on colors in another sheet (difficult !!) by [email protected]
Hello, big challange to make ! (for me). Perhaps somebody can help me out. In Sheet1 I have 66 Columns and appr 60 records. Column A = TextCode1 (like 3A,...
(Multi-page thread 1 2)
October 14th 16 02:01 PM
by isabelle Go to last post
12 373
Interior.ColorIndex of a field based on filled colors in other fieldsin the same row by [email protected]
Hello, I like to have a loop for colorsetting in column A, row 2 till last, based on the filled colors in the same row in column B till Z. If one of the...
0 142
Which activeX control currently has the focus? by Khuli[_2_]
I have a worksheet with a dozen or so activex comboboxes on. How can I tell in vba which one is currently active? (i.e. which one has the cursor in?) Thanks.
October 12th 16 09:18 PM
by GS[_6_] Go to last post
4 173
Copy format based on identical datafields by [email protected]
Hello, Struckling in previously obtained help and codes (thanks!) I want to built it up on another way and in some steps, so I can understand it better (also...
2 190
Check of related records in a column have data filled in in the next colum by [email protected]
Hello, Another question, In Column A several identical data is registered. Run all records of column A; For each group of identical data in column A all...
October 12th 16 06:28 AM
by Claus Busch Go to last post
1 178
Stupid Excel tricks by puppetsock[_2_]
So the following code: Public Sub addSheet() Sheets.Add After:=Sheets(Sheets.Count) Range("A6").Select End Sub It works just fine when it is in a...
October 11th 16 03:31 PM
by Bruno Campanini[_2_] Go to last post
3 228
VBA to delete link to inserted image by Steve[_123_]
I have a worksheet which contains a few hundred pictures which have been inserted with "Link to file." I want to keep the pictures but NOT have them linked. So...
October 10th 16 08:57 PM
by Steve[_123_] Go to last post
6 178
Copy a by macro special selected nr of rows into another file by [email protected]
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...
7 186
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 284
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 154
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 227
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 188
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 192
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 218
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 157
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 303
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 1,835
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 269
! 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 274
Post New Thread


Display Options
Showing threads 61 to 80 of 173994
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:48 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.