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
Sort isn't working correctly by GARYWC
The cells in col A and in col B contain the same data. All cells have a "General" format. Both columns are unsorted. I highlight col A and use DATA/SORT/SORT...
(Multi-page thread 1 2)
November 7th 16 01:42 AM
by Mike S[_5_] Go to last post
11 426
Sort isn't working correctly by GARYWC
The cells in col A and in col B contain identical data. All cells in both columns have a "General" format. Both columns are unsorted. I highlight col A and...
November 5th 16 05:57 AM
by GARYWC Go to last post
0 223
Convert date/time to serial number and compare serial numbers by GARYWC
How can I convert "2015:12:25 14:01:38" and "2015:12:25 14:43:31" (format: ccyy:mm:dd hh:mm:sec) to a serial numbers? How do I compare the resulting serial...
(Multi-page thread 1 2)
November 4th 16 10:53 PM
by GARYWC Go to last post
12 440
Path/File access error: '.\VB??.tmp' by Daniel Debes
Hi, I have seen many postings to this subject, but the solutions written in the postings didn't fix my problem. Excel answers with this Error message when I...
2 1,093
Excel automatic mail (Gmail), with conditions (verify cell content) by Lionelus
Hello everybody I would need some help for a tool I would like to create Here is the situation: I'm working in a young company, producing movies in France....
November 4th 16 05:41 AM
by vuvanxuongcntt Go to last post
1 598
Convert to serial numbers and compare serial numbers by GARYWC
How can I convert "2015:12:25 14:01:38" and "2015:12:25 14:43:31" (format: ccyy:mm:dd hh:mm:sec) to a serial number? How do I compare the resulting serial...
November 3rd 16 10:32 PM
by GARYWC Go to last post
0 252
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 08:02 PM
by GARYWC Go to last post
0 257
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 04:32 PM
by tinhdauhcm1 Go to last post
3 332
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 05:47 AM
by GS[_6_] Go to last post
7 313
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 296
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 297
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 248
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 251
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 590
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 286
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 280
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 584
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 493
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 192
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 226
Post New Thread


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