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
Unwanted workbooks on startup by kenrock
Hi, When I have been using Excel for Mac 2011, I have stored my macros in the Personal Macro Workbook which appears when I open Excel. I must have done...
October 10th 13 02:38 PM
by kenrock Go to last post
2 245
OFFSET LOOKUP function in VBA? by [email protected]
Hi - looking for a bit of guidance please. I am using a Userform to enter data into a database. Each database entry is entered as a new row and I have been...
October 10th 13 12:58 PM
by Claus Busch Go to last post
9 390
Need Help solving this equation by DeerSpotter
=IF((SUMIF(K25,"<0",K25))then(K25+P22+P21))*orIF((SUMIF(K25,">0",K25))then(K25-(P22+P21))) i am familiar with VBA a little... i understand the "or if" command...
October 9th 13 10:37 PM
by joeu2004[_2_] Go to last post
2 246
VBA CreateNames (ignores last 5 rows?) by Steven North[_2_]
I've got this Macro from Contexures to create names which I've incorporated into a macro that uses definedname ranges when it imports data from Access. It...
October 9th 13 03:01 PM
by GS[_2_] Go to last post
6 454
Code works but goes into endless loop and crashes by Howard
Looks up a number from sheet 1, Column A in Sheet 2 Column E, and posts offsets from both the left and right of that Col E number back to Column A. Once the...
(Multi-page thread 1 2)
October 9th 13 09:06 AM
by Howard Go to last post
16 455
Average data based on unique change in date, ignoring time by rbrookov
Hi, I have a question that is probably a combination of VBA & Excel formulas, so if I put this in the wrong location, please let me know & I'll move it. ...
October 8th 13 09:46 PM
by Claus Busch Go to last post
6 316
Adjusting height of text cells by Walter Briscoe
I write up to about 1000 bytes of text to a cell. Wrap is set. Sometimes, the cell is taller than it should be by a line of text. Up to now, most lines have...
October 8th 13 04:56 PM
by GS[_2_] Go to last post
3 337
How to read index value and selected text of dropdown excel in C# by [email protected]
Hi all I have to create a excel in which i have two ddl in cell of excel which binded with database.i have completed till now. My problem is how to read the...
October 8th 13 03:47 AM
by isabelle Go to last post
1 465
Copy value of textbox to clipboard for use in another application by Connie
On a userform I have created, I would like to add a command button to copy the contents of a textbox on the form to the clipboard so that the user can paste it...
October 7th 13 12:55 AM
by isabelle Go to last post
5 335
Indirect In formulas by no_name
Apologies for not making myself clear. I am using a macro to populate column A with the names of all the worksheets in the workbook onto a sheet called...
October 6th 13 02:32 PM
by Claus Busch Go to last post
1 239
INDIRECT informulas by no_name
I have a cell which has the code =INDIRECT("'" & Summary!A18 & "'!" & "A23") in it. I want to use this value in a COUNTIFS what should the syntax...
October 6th 13 02:20 PM
by joeu2004[_2_] Go to last post
2 266
Reference a workbook level named variable. by Dave Unger
Hello, I have a situation where 2 workbooks are open simultaneously, and Iím trying to reference a named variable (workbook scope) in the inactive workbook.. ...
October 4th 13 06:01 PM
by Dave Unger Go to last post
8 376
Too much data for this code? by Howard
First off, the main body of this code is way above my pay grade of vba. I googled it for a poster who has 8400+- columns by 150 rows data set. The goal is to...
October 4th 13 05:24 PM
by Dave Unger Go to last post
4 298
Sort partially hidden data by RJQMAN[_2_]
I have a vba sort command that sorts four columns depending on the integer in the first column - very straightforward - but I was getting erratic results. In...
October 4th 13 08:05 AM
by Dave Unger Go to last post
1 298
Excel application main window background by [email protected]
Hello All, Is it possible to add some picture or logo in Excel main window background ? I found many tutorials on Internet but all regards excel sheet or...
October 4th 13 01:04 AM
by GS[_2_] Go to last post
3 295
Object variable or with Block variable not set by Howard
This was working for me, and I must have change something to get the variable not set error. Thanks. Howard Option Explicit Sub FindNewPN()
October 3rd 13 11:09 AM
by Howard Go to last post
9 312
Excel crashes and restarts when accessing newly created worksheet by [email protected]
I am very new in VBA. Here is problem I am facing - I have to create multiple worksheets (Each having a button, I use a command button ) in a workbook.. All...
2 352
Not getting "argument type mismatch" by Dave Unger
Hello, When I compile the following code, I get a "Byref argument type mismatch", which is exactly what I'd expect to get. Sub test1() Dim l As Long ...
October 2nd 13 05:47 PM
by Dave Unger Go to last post
4 273
Formulas by [email protected]
I get that the following forumla can tell me the position of the first space from the right. Can I make it replace that space with a comma or semicolon or...
September 30th 13 10:09 PM
by David Marshak Go to last post
2 205
Run or Call a sub from the list of subs in a drop down. by Howard
If I have a list of ten sub names in a drop down F1, can I make my MySubCaller run the sub I choose in F1? This little diddy doesn't work and the scant info I...
September 30th 13 04:09 PM
by GS[_2_] Go to last post
8 446
Post New Thread


Display Options
Showing threads 1001 to 1020 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 02:47 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.