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
Select Case Code does not run... by Howard
Trying to do the obvious, run this code on the four sheets named in the case. Sheet names are correct, and code works just fine in another sub run on one...
(Multi-page thread 1 2)
October 15th 13 09:51 PM
by Howard Go to last post
10 372
Summing Percentages by [email protected]
I have a number that needs to be decreased based off a % improvement matrix located in my excel file. I'd like this number to be decreased by a user select...
October 15th 13 07:19 AM
by Martin Brown Go to last post
3 324
Getting information from access table in excel by [email protected]
I have inserted an access table into an excel sheet. I would like to populate a dropbox in a form with the data from that access table. I can do it by...
October 15th 13 01:28 AM
by GS[_2_] Go to last post
1 257
Convert code to lookup three criteria return fourth by Howard
Code by Claus that looked up four items and returned a fifth item. I need it to lookup three and return the fourth. First item is in column B6:B500+- Second...
(Multi-page thread 1 2)
October 14th 13 11:09 PM
by Claus Busch Go to last post
15 468
For Eachcell in Range tranpose comma seperated values to a list in D by Howard
This works great for cell A1 to rows in D. How do I modify the code to do A1:Ax into column D down as far as needed? My "Error 400" code attempt at it...
October 13th 13 11:24 PM
by Howard Go to last post
4 211
Unhide sheet, copy and rename new sheets from list, rehide sheet by Howard
I thank Garry of this forum for this code which I want to make into a generic scheme of: Unhide the sheet named "CopyMe" Make a copy/s and name it using the...
October 12th 13 02:59 PM
by Howard Go to last post
9 323
Comparing numbers by en2
Hi. I was thinking to make this in Java but if it's possible/simpler maybe i can do this in excel... I have columns A, B, C, D, E filled with 30 rows of...
October 11th 13 04:17 PM
by GS[_2_] Go to last post
1 291
modified pivot table using a macro by oercim
Hello, I need help. I need to create a table using a macro which resembles like pivot table. For example let , the data is like below on sheet1 A ...
October 11th 13 07:50 AM
by oercim Go to last post
2 253
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 253
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 400
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 258
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 466
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 469
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 326
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 349
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 495
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 349
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 249
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 278
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 390
Post New Thread


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