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 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 289
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 283
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 301
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 346
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 262
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 200
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 405
Worksheet_Change Woes by Living the Dream
Hi Guys I am wanting to use the following code, which to an extent works, but then fails on the 2nd IF. this code is attached to the Inbound Sheet. Private...
September 30th 13 10:35 AM
by Living the Dream Go to last post
6 352
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet by Howard
Can I copy FndPrd to a list on the same sheet and/or to another sheet. What I have gives me TRUE in K2 and I have marching ants around the ..Union arguments 1...
(Multi-page thread 1 2 3)
September 29th 13 09:20 PM
by GS[_2_] Go to last post
27 808
How do I exclude a cell from a range? by [email protected]
I want to exclude a cell from a range of data. That cell may or may not be at the extremities of the range. Say I have the range for column A, A:A and I want...
September 28th 13 08:23 PM
by GS[_2_] Go to last post
4 530
Macro to copy row based on value into new sheet of same name by frankjh19701
I have a large Excel worksheet with info sorted by date. The columns, from left to right, are "Date", "Origin", "Employee", "Vehicle #", "Product Count", and...
(Multi-page thread 1 2)
September 27th 13 07:58 PM
by frankjh19701 Go to last post
11 1,339
Paste Special Values by Howard
Isn't there a plain jane 'one liner' to past special values? This works to the .Resize(1, 2).Copy then fails. Thanks. Howard For Each c In...
September 27th 13 03:10 AM
by Howard Go to last post
3 243
1 Attachment(s) Combining Multiple Schedules into One Schedule by Miracle Man
Hello Everyone, Today I present a problem I am certain a solution exist for. The file is attached below to help better understand the situation. I have...
September 26th 13 07:05 PM
by Miracle Man Go to last post
0 230
Programatically changing the macro content. by [email protected]
Hi everybody, is possible to change Excel macro content by another macro? I often use to copy and paste some code samples from PDF files and there is a problem...
September 26th 13 12:58 AM
by GS[_2_] Go to last post
1 288
Add a Value to a Cell Q by [email protected]
Looking for some code that would apply a certain amount to each cell in a range. In my scenario I have a price list in B1 to D20, I want to add 20p to each...
September 22nd 13 08:46 PM
by isabelle Go to last post
2 288
filter function by Johnnyboy5[_2_]
I have a main sheet with a list of 51 unique names in Column B and then lots of data in other columns across the sheet. I have other sheets in the same same...
September 22nd 13 03:53 PM
by Johnnyboy5[_2_] Go to last post
0 248
Pass condition formatting across worksheets via vba. by Living the Dream
Hi guy's Currently, I have this working very well. .................................................... Private Sub Worksheet_Change(ByVal Target As Range) ...
September 22nd 13 12:22 PM
by Living the Dream Go to last post
0 194
Create if partial match then copy and paste data from one cell to another by [email protected]
Hello, Hopefully, I can explain this well which is probably half the challenge. What I am trying to accomplish is a bit complicated. For the purpose of...
September 22nd 13 08:06 AM
by Auric__ Go to last post
1 425
Get/Find criteria and copy sum by Living the Dream
Hi all I know the subject title is a little vague, so here goes. What I would like to achieve is: One of the DC points that gets trucks actually unloads...
September 22nd 13 03:36 AM
by Living the Dream Go to last post
2 344
remembering the same filtering criteria by [email protected]
Dear All, I would like to know that is there any way of recording criteria when I filtered data. For example; A1,A2,A3,A4,A5,A6,A7,A8,A9,A10 and A11 I have...
(Multi-page thread 1 2)
13 471
Post New Thread

Display Options
Showing threads 1001 to 1020 of 174022
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 07:17 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.