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
Convert dates and times into serial number and compare serial numbers by GARYWC
Columns B thru G each contain a combination of a date and a time (format: ccyy:mm:dd hh:mm:sec) How do I convert the contents of each cell to a serial...
November 3rd 16 07:02 PM
by GARYWC Go to last post
0 410
Copy Active Sheet by [email protected]
Could someone assist me with a simple VBA that will copy the activesheet to a sheet called "Input" retaining all formats etc? Thanks
November 2nd 16 03:32 PM
by tinhdauhcm1 Go to last post
3 481
Huge data set Find-Replace by L. Howard
Is it possible to use something like this example for find replace except just for single sheet with a huge data set, say 300,000 - 600,000 cells? The built...
November 2nd 16 04:47 AM
by GS[_6_] Go to last post
7 465
Macro to Insert Picture by [email protected]
I have the following Macro which I use to insert pictures in Excel 2010 that worked fine but now I have converted the file to Excel 2013 and I am have 2...
0 428
Simple array macro works on one sheet only by L. Howard
This in a standard module only works on the sheet from which it is called. Should it not do all four sheets run from any sheet? Howard Sub Plain_Copy() Dim...
October 27th 16 03:59 AM
by binhduong259 Go to last post
6 421
Earliest date & time by GARYWC
The dates and times are still in A1/B1 and in C1/D1 and the serial number is in E1. Which date and time does the serial number represent?
October 27th 16 03:15 AM
by Xuân76385 Go to last post
2 394
Copy from workbk & Paste to project window by [email protected]
Is there a way to write a macro of function that would copy from a worksheet. then open VBA GoTo.mymacro then select all from that module and then paste what...
0 399
Search Word document based on text in Excel cell. by Ronald[_4_]
Hello all, I have this recurrent task where I need to search trough a document for a bunch of keywords and highlight them somehouw, preferred with a different...
(Multi-page thread 1 2)
October 25th 16 12:21 PM
by Claus Busch Go to last post
17 806
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 424
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 449
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 803
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 702
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 292
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 328
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 374
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 357
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 402
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 320
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 351
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 517
Post New Thread

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