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
Split data in one cell like ALT-Enter by [email protected]
If somebody can help me out :) I have a sheet with several rows. In column D a lot of text is included with separator slash. I need a macro that produce the...
0 1
Excel 2007 VBA: Convert laaaaarge number to Hex by nj
Hi, folks, We're trying to get a subroutine working for converting numbers like 37719831058777893 83881713106708998 37156879353577176 37719831058778503 to...
(Multi-page thread 1 2 3 ... Last Page)
32 1,768
Can protect worksheet then workbook but not Protect and Share in code by [email protected]
Hi, I am trying to pw-protect the sheet, the pw-protect workbook and the pw-protect sharing in code. I can do this manually in Excel but not in Excel VBA or...
7 288
Web reads - synchronous and asynchronous - long by Walter Briscoe
Last year, Garry pointed me at synchronous XML HTTP read techniques. They are faster than calling Internet Explorer from Excel. Asynchronous access has...
January 11th 17 06:36 PM
by GS[_6_] Go to last post
1 118
grouping cells within a column for a chart by [email protected]
I have many cells in one column that I would like to chart. I would like to group them to make the chart more readable. 49-55 is one group 78-84 is...
0 87
conditional formatting, bleh by Matthew Dyer
trying to use this formula for conditional formatting in column D: =NOT(ISNA(VLOOKUP(D1, SLS_Holidays, 1, FALSE))) where any value in D that is found in...
January 6th 17 02:52 PM
by Matthew Dyer Go to last post
7 115
Conditional selection and printing of sheets by [email protected]
Is it possible to select and print alls sheets in a workbook where M42 is >0 in one print, or do I have to print each sheet at a time. Jan
0 77
Copy Row Above, with a Twist Q by [email protected]
I have several Blank rows above each is a row of data (covering columns A-D), what I want to do is populate each blank row with the following:- Col A - Copy...
8 76
How to I use nested quotation marks for 'SUMIF' function in Excel. by Glenn
I'm writing a macro, creating a formula for an active cell using "SUMIF". I need to use cell references that I can control via variables (aka 'cells' with...
3 151
Add background watermark to cells? by Robert Crandal[_2_]
I have formatted cells A1 through G1 with a background fill color of my choosing. Now I'm wondering if it's possible to add a background watermark message to...
6 1,454
Why full path in the formula to an UDF function? by hbj
I have a project, which uses UDFs, running in several computers. When I open the file in computer 1, after I saved it in computer 2, the call to a formula in a...
December 30th 16 02:33 PM
by hbj Go to last post
6 453
File cannot be accessed by [email protected]
Hi I have a macro that sequentially opens data files (csv data in .rnd files), copies data to the main workbook, then closes the file. This normally works well...
(Multi-page thread 1 2)
11 733
Claus by Paul Doucette
Happy Birthday!!! :-)
December 17th 16 05:34 PM
by Paul Doucette Go to last post
3 246
select case help by Matthew Dyer
in this case my case is a string (see what I did there???) I want to test if case contains substrings but am coming up blank. logic im trying to...
December 15th 16 02:00 AM
by bdshl009 Go to last post
3 217
FreezePanes is a window property by Walter Briscoe
I run Excel 2003. I have a particular workbook, consisting of 3 sheets. Sometimes, I save it with one displayed sheet and sometimes with more than one. Each...
December 11th 16 01:42 AM
by GS[_6_] Go to last post
9 233
close a pdf file opened via shellexecute by Matthew Dyer
I am using the following code to open a pdf file. Private Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hwnd As Long,...
December 10th 16 07:07 AM
by GS[_6_] Go to last post
4 173
data connection table date help by Matthew Dyer
I have data connection pulling a SQL query, I am using: CONVERT(VARCHAR(10), TASK_DATE_CREATED, 101) AS to create the Task Orig Date field. However, this is...
December 8th 16 10:32 AM
by Sandytran144 Go to last post
2 200
SQL help? group? anything? by Matthew Dyer
So I'm starting to expand my 'data' knowledge into relational databases and wondering if there's a google group out there similar to you'se guys. the ones I've...
December 7th 16 09:26 AM
by Luannguyen992 Go to last post
4 190
User-defined type not defined by Walter Briscoe
In another thread, today, I mentioned Regular Expressions. The subject of my posting is an XL 2003 Compile error. I regularly find people mention user-defined...
December 1st 16 01:07 AM
by Peter T[_7_] Go to last post
5 280
replace() funciton with multiple tests.... by Matthew Dyer
so basically I'm looking to do the following, which obv doesn't work... Replace(string, Or("purge_", "dealdrop_"), "cor010_wcout") I've tried Replace(string,...
November 29th 16 04:35 PM
by Walter Briscoe Go to last post
3 228
Post New Thread


Display Options
Showing threads 1 to 20 of 173995
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 11:13 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.