Copy and paste sheets to new workbook7943 (6/7/2010 11:57:23 AM) Stav19Hi All
What i would like to do is to select 4 sheets and copy them into a new
workbook. I would like the sheets to be values and to have the same
page layout as the original sheets. The worksheets I'm co...
Fill Down to Last Value21197 (6/7/2010 3:11:36 PM) UtfI have 2 spreadsheets (Sheet 1 and Sheet 2). Sheet 1 has one header row and
sheet 2 has 2 header rows. I am using the following to count the number of
rows in Sheet 1 and copy a formula to every row in Sh...
Passing dates to Sql Server 2005 stored procedure31127 (6/7/2010 9:50:58 AM) UtfHi,
I am trying to execute a SQL Stored procedure from Excel using VBA. Apart
from 2 string inputs, this proc also accepts two datetime imputs. When these
dates are passed via VBA, they are in the format...
Sharing Macros 06-07-1011145 (6/7/2010 2:31:44 PM) UtfHello,
I have created a template to be used within my group on the department share
drive and it contains macros. How do I allow the other users to run the
template on their computers if the macros on st...
another filtering question1728 (6/7/2010 2:02:24 PM) UtfI was assisted with the following code, which filters two pieces of data--a
case manager ID (###A from column B) and a program code (MA from column C):
How to add a "running count" to cells with matching data21628 (6/7/2010 4:15:36 AM) UtfI want to copy column A (below) into Column B and add a running count.
As long as column A is the same (repeat letters & numbers) - it keeps adding
the next number (1,2,3 . . . up to 99).
Example - Cols...
Why does saving take SOOO long?32205 (6/7/2010 8:21:03 AM) MichelleOn my colleague's machine an Excel 2003 file takes 4 or 5 seconds to save
On mine the same file take between 22 and 25 seconds.
My PC has a stonking big powerful dual-core processor (the laptop cost...
Environ("username") in 200742487 (6/7/2010 9:09:29 AM) Utfdebug.Print Environ("username") does work on 2003 but not on 2007?
I have read other posting with a similar question and it is written ther
"problem is solved by changing the environmental variables" - how...
Recalculate a worksheet following an autofilter selection.11100 (6/7/2010 9:50:59 AM) UtfHi
I'm trying to work out how to recalculate a worksheet once a filter
selection has been made.
I think I need to use a worksheet selection change event but I do not know
how to detect the filter chan...
macro to insert row and type data21415 (6/7/2010 12:07:23 PM) UtfI have a worksheet that contains groups of data for different products for
each month, which I update each month. The last row in each group of data
contains a cell with the word "END" in it. I would like...
MsgBox refer to seperate worksheet2822 (6/7/2010 9:42:55 AM) UtfHi - I need to set up a message box that will read a cell on another
worksheet. The button for the msgbox (an where I want it to pop up) is on
the Questions worsheet. The code I have is below;
Can I 'toggle' a toolbar button11556 (6/7/2010 9:06:41 AM) MichelleStill using v.2003, how can I make a button that I put on my toolbar have
two states like the 'bold', 'italic' or 'drawing-toolbar' buttons?
these buttons appear 'illuminated' or 'depressed' when switched
Need help in highlighting the cell color in VBA3630 (6/2/2010 4:12:47 AM) xllearner
I am new to the excel VBA. Your help is appreciated. Please Help me in
vba code for the following points.
I have attached the sample file of how i get and what changes would
required once af...
Functions newsgroup101202 (6/6/2010 5:49:30 PM) OttoWhat happened to the Functions newsgroup? Its gone. Is this the start of
the demise of the Microsoft newsgroups? Where would I go to find the forums
they talked about in a recent posting?
Thanks for you...
automatically unprotect vba-project11913 (6/7/2010 8:36:43 AM) UtfHi,
is it possible to unprotect a password-protected excel-addin by code or does
the user needs to enter it allways manually? neither the unprotect method of
the coressponding workbook object nor the pas...
Sync parts of two worksheets including formats01131 (6/7/2010 7:57:01 AM) SteveI am looking for a way to have a primary and secondary worksheet. I will
make changes to the primary and want those mirrored on the secondaary sheet.
I want o mirrow all changes, formatting, adding, delein...
Float Menu Excel 2003 vs 200711095 (6/7/2010 5:52:29 AM) UtfHi All
In a  workbook I've got a "help sheet" with various help topics.
When activated a float_menu appears from which the user can
select a topic from a userform. This works great, however in 2007
Referencing conditional format is another workbookHI7751 (6/4/2010 6:33:10 PM) UtfHI all,
I hope someone can help me come up with code that will conditionally format
a summary sheet(scorecard) based on the conditional formats in another
workbook. I used Excel driven conditional forma...
Conditional max0937 (6/6/2010 11:49:04 PM) UtfTrying to find working VBA code for the following problem:
a=maxif(column(a), column(b) = 1, column(c) <> empty)
value = maxif(range, condition, condition)
Arranged in table so that the max value is re...