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
Print specific range but user to select printer by Code Numpty
Hi, I have the following in one of my macros to print to the default printer. Worksheets("Disinfections").Range("pen_list").PrintOut How do I change this so...
December 31st 09 05:52 PM
by Code Numpty Go to last post
4 184
Saving a Workbook cause's Error's by Brian
I have a User Form with a Control Button for assigning the name & saving the Workbook. The Problem is when the Save As Dialog Box pops up the File name is...
(Multi-page thread 1 2)
December 31st 09 05:09 PM
by Brian Go to last post
10 250
Dae format by SR
how can we convert the date format, suppose I am entering the date as 09/09/2009 using an input box, the macro should take the date as 9/9/2009. Please help
December 31st 09 05:03 PM
by Harald Staff[_2_] Go to last post
3 169
How to Determine When Calculations are Complete by Alan[_8_]
I have some (many) equations in a spreadsheet. I have to change a cell in the spreadsheet, which affects all the calculations, until certain conditions are...
December 31st 09 04:14 PM
by Joe User[_2_] Go to last post
3 158
Automation Security and unexpected program termination by Arne
I want to open an Excel workbook which I know is read-only (password protected), and contains code. To load the file and to disable the code, I...
December 31st 09 03:54 PM
by Arne Go to last post
5 435
Fn = Cn * En by abhi
PLSSSSS I AM DYING.........FOR GOD SAKE TELL ME THIS........ Fx = Cx * Bx where "x" is 1,2,3,4,5.................. means i want to generalize a...
December 31st 09 02:52 PM
by Matt S Go to last post
2 165
Multi controls code by אלי
Hi! I have on a userform 8 spreadsheet activeX controls, and I want all of them to do the same thing. Do I have to write the same code 8 times or there is a...
December 31st 09 02:16 PM
by Dave Peterson Go to last post
8 240
I need a program created for Excel by Dan From Bay State School
I work at Bay State School of Technology and we are in need of a somewhat advanced calendar/planning excel program that would display...
December 31st 09 02:07 PM
by Don Guillett Go to last post
1 178
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 191
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 166
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 288
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 190
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 180
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 128
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 297
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 210
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 208
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 163
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 156
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 176
Post New Thread


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