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
Macros to Refresh all filled Cells. by Akash Maheshwari
Hi, I have used a concatenate function for clubbing two cell values. After clubbing the value is =Sheet1!D2. I have used paste special as values in 50 Cells...
October 25th 16 03:20 AM
by dienmaytrangiaabc Go to last post
3 370
Earliest date and time by GARYWC
Cols C, D and E have cells that contain either a date & time or spaces * 2016/10/21 22:00:01 2016/10/17 10:57:40 2016/10/17 10:57:40 2016/10/15 07:07:02...
October 24th 16 10:37 AM
by hahuvoibimat Go to last post
1 378
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 730
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 623
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 252
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 294
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 329
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 315
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 366
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 284
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 307
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 464
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 252
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 347
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 332
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 299
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 363
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 274
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 459
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,690
Post New Thread

Display Options
Showing threads 101 to 120 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:35 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.