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
Intersect operation by Walter Briscoe
I hope readers here can help. I am having trouble developing an array formula in a worksheet. Once I have the appropriate symbols, I would like to run...
March 22nd 17 11:25 AM
by Walter Briscoe Go to last post
1 109
I need help getting spreadsheet names from closed file using ADODBwith tab order by Ahmed A
I am able to successfully connect and query specific sheets. Some files I am dealing with may have the first spreadsheet name different or changing and...
March 19th 17 11:41 AM
by GS[_6_] Go to last post
2 156
how to use ADO to get sheets from closed file and the excel tab order(figured out with DAO) by Ahmed A
This is what I built the other day with DAO but I still want to figure out ADO... Public Function GetSheets(ByVal FileToOpen As String, ByVal FileExt As...
March 19th 17 10:48 AM
by Ahmed A Go to last post
0 117
help with loop code by eltyar
please how can i say in this code... do it when you see "ok" in cells of column "P" and if any empty cells ignore it and continue? this is the Code: I = I +...
March 16th 17 06:43 AM
by eltyar Go to last post
2 199
Help with Counting Multiple Criterias by Munster
Hello, I am in need of a formula that will count how many times baseball was played and won. I keep Value errors and N/A errors when I try formulas like...
2 139
Rename files with VBA by michelle439731
Afternoon, I want to rename some files in a folder using vba. Preferable what I would like to do is a)find file x in folder a b)rename file x to xy Please...
March 14th 17 02:30 PM
by TIMOTHY Go to last post
9 290
Customized Inventory Software Required in Excel VBA by Hitesh Kr. Aoul
Hello, I need a help to make a customized Inventory software for our newly setup business, In which we required 2 login id's, 1. is for Local User and other...
March 7th 17 11:34 AM
by Auric__ Go to last post
1 321
Syntax for Cell type by Tim Childs[_10_]
Hi In VBA I want to get the cell information on a cell e.g. in the Application itself, I can put: =CELL("type",A1) in Cell B1 However, I would like to...
March 5th 17 09:36 PM
by Peter T[_7_] Go to last post
8 284
VBA- Finding texts built from regex patterns by stainless[_2_]
I need to recognise patterns in text starting with a specific variable text value and ending in 0-3 numeric values. For example:
March 5th 17 06:57 AM
by Claus Busch Go to last post
3 160
Excel Help!! by hayley_n2008
How would I write an excel formula using the following conditions? I keep getting an error message and I dont know what I am doing wrong Buy if the stock...
March 2nd 17 05:09 AM
by isabelle Go to last post
2 197
Delimiter(?) by GARYWC
How can I separate data preceded by '<<' (without the quotes) into different columns? Here's sample of my text file: << NOT a relative>> << Anyone...
February 26th 17 11:35 PM
by GS[_6_] Go to last post
4 239
Excel export to Outlook:- Missing Microsoft Outlook 16.0 object library by [email protected]
Help please! Using assistance from online resources I have VBA to create an Outlook contact from an Excel spreadsheet. I was told the machines it was to work...
(Multi-page thread 1 2)
February 25th 17 08:30 PM
by GS[_6_] Go to last post
10 310
separating text and numbers into different columns by Paul Doucette
If I have sv14 in a cell, is there a formula I can use to copy the text characters into one column and the number into another? The number of text characters...
February 21st 17 05:03 AM
by isabelle Go to last post
1 176
Create an array based on the subroutines in a module by Matthew Dyer
here's an interesting thing... I have multiple closely related but specifically individual subroutines clustered in one module (Verbiage). I know that there is...
February 16th 17 03:25 PM
by GS[_6_] Go to last post
5 263
Controlling xlTiled windows arrangement by Walter Briscoe
I have a new machine using xl2007 on Windows 10. I believe what I have observed also applies to xl2003 on Vista, but have not tested it I have windows with...
February 14th 17 12:15 PM
by Walter Briscoe Go to last post
0 202
Several issues by [email protected]
All, I want to create a macro that first opens a dialog box where the user can select a worksheet to open from their documents. To be more specific, I want...
February 11th 17 03:08 PM
by gioinguyen372 Go to last post
4 349
2 Attachment(s) Formula to extract certain texts by ecdlc888
Good day.I need help to extract certain texts in column A to place to columns B,C and D as in the attached file. Those are the ID, azimuth and distance...
February 7th 17 11:05 PM
by ecdlc888 Go to last post
3 369
Simple alpha numeric sorting by [email protected]
Hi all, I have absolutely NO experience with excel, and I am trying to sort lot numbers which are followed by a letter; eg: 1B 5B 19B 45B 190B 247B 560B
February 6th 17 12:15 AM
by Claus Busch Go to last post
1 250
Comparing two columns in different sheets by [email protected]
In Sheet1 I have peoples names and addresses. Names in column A, and addresses in B-column like this: Mystreet 23, 2.th. Your Street 5, aptm. 345 Carl Bark...
9 352
Change event for all sheets in WBook by L. Howard
This works to hide/unhide for only the activesheet. I need if I enter CS or SA on ANY sheet cell H8, then ALL sheets hide for that case, regardless what the...
February 3rd 17 09:02 AM
by L. Howard Go to last post
5 219
Post New Thread

Display Options
Showing threads 21 to 40 of 174035
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 05:27 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.