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
Runtime Error 381 - Invalid Property Array by [email protected]
Hello All, {Excel 2007, PC, novice} I have a userform which contains a ComboBox showing the bound column data. It supplies two Text boxes with data from...
5 1,426
delete all rows except by J.W. Aldridge
need to delete all rows except those containing "apples" and or "oranges" in column G. code below works, just need to add second criteria. assuming that "a"...
May 1st 09 12:44 AM
by JLGWhiz[_2_] Go to last post
5 185
Export unlocked cells to file by dan dungan
Hi, Using Excel 2000 and Windows XP, I'm attempting to export all the values in unlocked cells on the active sheet to a text file on my c: drive. Here's my...
May 1st 09 12:05 AM
by Dave Peterson Go to last post
4 145
Copy/Paste Template to New Workbook by Polo78 Lacoste
I have a template with two worksheets, sheet1 with the actual template which has about 20 vlookups and other formulas. Sheet2 contains the range for the...
(Multi-page thread 1 2)
April 30th 09 11:21 PM
by Polo78 Lacoste Go to last post
11 279
Problem with customized RichText Control by RB Smissaert
As there is a security problem with the regular RTF control, RICHTX32.ocx, somebody made for me a customized RTF control based on the regular RTF control. I...
April 30th 09 11:07 PM
by RB Smissaert Go to last post
1 153
looping on excel files in directory by christopher ward
Hi All If you can help my kindest thanks and sorry if I do not explain my issue very well - I am no longer a programmer being old and grey ( whats left ) I...
April 30th 09 10:42 PM
by Eddy Stan Go to last post
5 201
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC by MattW[_2_]
I am attempting to create an excel pivot table programatically using the Excel 12.0 Library. The code I am using is below and I have marked the point where...
April 30th 09 10:30 PM
by MattW[_2_] Go to last post
0 423
Problem using group function with hidden rows by jday
I have a worksheet containing 10 sets of rows containing different versions of data. Within each of these 10 sets, there are "grouped" rows that can be...
April 30th 09 09:55 PM
by jday Go to last post
0 266
import from excel to access with macro? by J.W. Aldridge
Have existing access table. Imported data from the following source. C:\Documents and Settings\jw\Desktop\Sheet3 Need macro in access that will return to the...
April 30th 09 09:05 PM
by J.W. Aldridge Go to last post
2 132
replace text with a loop by Scooter
If I wanted to replace text "A3" with "A4" I would do this Cells.Replace What:="A3", _ Replacement:="A4", _ LookAt:=xlPart, _ ...
April 30th 09 09:04 PM
by Rick Rothstein Go to last post
6 214
Print To pdf Wait For Save As Completed by jutlaux
I am CutePDF Writer to convert a excel sheet to a pdf via a macro. I have 2 questions: 1) How can I have my code wait after the print command for the user...
April 30th 09 09:00 PM
by jutlaux Go to last post
0 126
Application.GetSaveAsFilename problem by Bishop
I have a userform with a button that does the following: Private Sub PanicSwitch_Click() Dim AUserFile As Variant Month7Select = Month7.Value ...
April 30th 09 08:56 PM
by Dave Peterson Go to last post
3 270
VBA: Code to Clear IE Cache by [email protected][_2_]
Can someone please provide me with the coding to clear my IE cache? Thanks
April 30th 09 08:46 PM
by RB Smissaert Go to last post
1 353
Form Control Text box by newguy
I am trying to use a form control text box to hide tabs in a worksheet and I cant seem to get it to work any suggestions. Sub CheckBox_Click() If...
April 30th 09 08:45 PM
by Dave Peterson Go to last post
9 203
Pivot Table Field List by mark
I got it wrestled back into position. never mind. thanks. "mark" wrote: > My Pivot Table Field List has rudely attached itself to the top of the Excel >...
April 30th 09 08:44 PM
by mark Go to last post
0 247
Command Bars by jfcby
With the macro below is there a way to add a custom button to the Toolbar without deleing then recreating it? Sub CreateOtherCommandBar_Test1() On Error...
April 30th 09 08:43 PM
by Dave Peterson Go to last post
3 149
Pivot Table Field List by mark
My Pivot Table Field List has rudely attached itself to the top of the Excel application window, above even the menu. I can turn it totally off by clicking...
April 30th 09 08:30 PM
by mark Go to last post
0 102
User form close by slarbie
I'm quite sure this is a silly question but I need to ask it anyway. If the "x" on the upper right corner of the user form is used to close it, does that...
April 30th 09 08:13 PM
by JLGWhiz Go to last post
2 113
ActiveX control causes "Reset project" notice on file open by GeoBrooks
I've added two combobox controls to an XL2007 macro-enabled workbook because I needed to capture their values b4 they were changed. Now when the workbook is...
April 30th 09 08:11 PM
by GeoBrooks Go to last post
4 123
I need to check for a number in a column before continuing on by Don M.
I have written a macro to look for a number in a column then continue with the macro. The problem is that these numbers are no consecutive and some numbers...
April 30th 09 08:06 PM
by Don M. Go to last post
1 167
Post New Thread


Display Options
Showing threads 20001 to 20020 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 12:55 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.