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
GoalSeek 1004 Error by Jason
I am trying to use the GoalSeek function in my VBA, but am unable to get it to work, I have been getting 1004 error Here is the line that seems to cause the...
December 31st 09 10:49 AM
by Niek Otten Go to last post
5 179
Select method failing by CDM
I'm trying to remove a header row in a different spreadsheet with the following code. Everything goes OK until it gets to .Range("A1").select. It gives me an...
December 31st 09 06:52 AM
by Jacob Skaria Go to last post
1 151
toggle between 0 and 1 by Robert Crandal
Is there a binary operator in Visual Basic that will toggle a variable (initially set to 0) between 0 and 1??? I know I could use a bunch of if-then...
December 31st 09 06:40 AM
by Rick Rothstein Go to last post
9 264
Conditional Formating Issue by Thomas Dieter
Okay, I have a problem with a set of conditional formatting. I guess the easy way to explain this is to give the values of cells in question, and the setup...
December 31st 09 04:20 AM
by Thomas Dieter[_2_] Go to last post
1 168
Changing Tab order - easier method?? by Roger on Excel
I have a userform with hundreds of textboxes on it They are not in any particular Tab order and rearranging them is going to be a major undertaking to put...
December 31st 09 02:21 AM
by Roger on Excel Go to last post
3 169
insert rows and copying cells in column b,c, and d into new ro by gbpg
"joel" wrote: > > Where do you want to copy the data (in the middle or end of data) and > how many times do you want to repeat the process. > > > -- >...
December 31st 09 01:05 AM
by gbpg Go to last post
0 118
insert rows and copying cells in column b,c, and d into new rows by gbpg
"gbpg" wrote: > I currently have a spreadsheet that contains many rows of information > exported from another application. In column a I have the same rows...
December 31st 09 12:34 AM
by gbpg Go to last post
0 285
Error Message by oldjay
Using Excel 2007 and Win 7 The following macro has suddenly started displaying the error message even thou the file is saved correctly to the server. Private...
December 30th 09 11:50 PM
by oldjay Go to last post
2 192
Copy whole table into one cell by macropod[_2_]
Hi Nit_Wit_400, If your concern is to have each group of records appear together on your final mailmerge report, there's no need to try to get them into a...
December 30th 09 11:41 PM
by macropod[_2_] Go to last post
7 186
Need help-For loop by SR
Hi All, I am new to excel programming, below is my code , it will take the date from user and search for the date in all the sheets in the workbook. I am...
December 30th 09 11:04 PM
by OssieMac Go to last post
1 150
Open Excel from a VB6 application then use "Find and Replace" form by Dan Tabla[_2_]
Hi all, I need to open Excel from an VB6 application and run the "Find and Replace" form using a value that the VB application has it. I like the "Find and...
December 30th 09 09:37 PM
by Dan Tabla[_2_] Go to last post
2 145
Close Worksheet and Making Worksheet Invisible - Both fail by ekareem
Hi, I use this (pardon the variable names...) infile = "C:\Temp\Garb-Tests\Test1\solTrip.xlsx" insheet =...
December 30th 09 09:15 PM
by ekareem Go to last post
2 163
Help with autofilter and filtering a specific column by Drew[_11_]
in a macro that filters a specific column i have the following code... ActiveSheet.Range("A7:CQ199").AutoFilter Field:=31, Criteria1:="=3", _ ...
December 30th 09 09:11 PM
by OssieMac Go to last post
1 133
Detect "Save" menu event by Robert Crandal
How can I handle when the "Save" menu option is selected by a user?? I basically want to run some code either before or after a workbook save occurs. Does...
December 30th 09 08:46 PM
by Harald Staff[_2_] Go to last post
1 140
Automatic Refresh Date and Time by jaeson
Good Day, Can you help me into my problem using Excel 2000, I just want is when I'd Put =Now() in cell A1 it will aumatic running without pressing F9...
December 30th 09 08:41 PM
by Dave Peterson Go to last post
1 150
Better Understanding by Marsh
I am in the process of beginning to teach myself VBA for Excel 2007. The primer I am using starts with recording macros, editing recorded macros, and...
December 30th 09 08:35 PM
by Harald Staff[_2_] Go to last post
4 259
xl2007 - Slow Macros Involving Graphics by Greg Wilson
BACKGROUND: I developed an interactive Excel-based program for the engineering and construction industries using xl2003. It is essentially a picture...
December 30th 09 08:17 PM
by Greg Wilson Go to last post
3 202
Download a .csv file from a website by talkintotim
I was wondering if anyone knew how to code this with vba. I have a list of stocks in a spreadsheet, and want to download the .csv file from Yahoo historical...
December 30th 09 06:46 PM
by talkintotim Go to last post
0 161
Set focus to textbox after spin-button control is pressed?? by Homey
I try this an have same problem. it seem that where focus is at click control where focus go. if focus on spinner then focis go to textbox. but if focus on...
December 30th 09 06:39 PM
by Robert Crandal Go to last post
1 286
Worksheet function by Atif
Hi all, i am using following code to copy values from Source Workbook to Target Workbook, its working fine. vSourceWS.Range("A1").Copy...
December 30th 09 06:24 PM
by Rick Rothstein Go to last post
6 222
Post New Thread

Display Options
Showing threads 10001 to 10020 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 06:44 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.