Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / June 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Dates28 Jun 2006 05:50 GMT1
Any one know how to set up dates like in roll A:1 to 31 and as you stroll
down column the roll A follows down to roll M so you know where  you can add
numbers to date with out have to stroll up to be sure your in the right spot?
Use a button to copy the values of one range to another28 Jun 2006 05:35 GMT3
Please give me some help with this
I have  a range on Sheet1 and a range of the same dimension on
Sheet2 . I need code for a button on Sheet1 that when pressed copies
the values of the range on Sheet2 into the range on Sheet1
help creating helper column28 Jun 2006 05:18 GMT1
I have a situation where I need to compare week1 from one year to week1 from
another year.  The problem is that I have the dates, amounts, and categories
in a raw dump from an external application in a text file and am able to
import it into Excel.  The issue that I need to do is to ...
Graph Source Data28 Jun 2006 05:10 GMT1
Is there a way to make a graph  source data pull only the last 14 days of info ??  
I have a data source that gives me 90 days of info, but on one graph, I want to limit it to
the last 14 days and not have to manually adjust it every day.  
Brian
Move WorkSheets Within Same WorkBook!!28 Jun 2006 05:02 GMT3
I've created a workbook with 80 worksheets. Now I have added 40 worksheets.
The problem is I need to move the added worksheets but I can't use the work
sheet names to move the worksheets with the following code
Sub ORGANIZE_WORKBOOK_SHEETS()
Input Box value saves wrong WorkBook file & AUTO Sheet Numbering (1,2,3,4...)28 Jun 2006 04:55 GMT1
Thanks 1st to all that have assisted me with these codes thus far.
RE : Below Code/s.
I have a macro (macro11) that when a designated number of sheets is reached,
a box states this and prompts a value to SAVE the NEW wb as "???"
Close All and Workbook_BeforeClose events28 Jun 2006 04:34 GMT6
I've encountered the following problem that I wonder if anybody else has
encountered.
I have an application that is implemented as an Excel add-in.  Each workbook
that contains application data contains a Workbook_BeforeClose event handler
Paste Append?28 Jun 2006 04:24 GMT1
I am trying to copy data from one worksheet to the end of the data on
another worksheet. I found this macro but it only works with one row.
Perhaps someone can help me modify it.
Thanks
Do Until Question28 Jun 2006 03:17 GMT7
I'm using the following code to number each cell in column A if there is a
value in column B.  I need help setting my variable 1 when it start.
Sub count1()
Dim i As Integer
VBA cell values28 Jun 2006 02:44 GMT1
OK, I seem to be mis-coding this. Can anyone tell me what is wrong with
this VBA code?.....or a better way to do it?
*******
This line is supposed to return a value in a specific cell based on
Open Hidden sheets to specific point28 Jun 2006 02:38 GMT2
Lets hope my internet won't crash before this one posts...AGAIN...lol
I have hidden sheets that I have got a macro to open once the button is
selected, but I want the macro to open at a specific point.
Here is the END only of the macro
Single Macro containing multiple subs28 Jun 2006 02:20 GMT2
I'm trying to write a macro that will check numerous 'If.. Then'
statements and if the condition is met it goes out to a share point and
retrieves a specific Excel file.  As soon as it opens that file it
returns to the original macro and checks the next If..then statement.
lookup28 Jun 2006 02:13 GMT1
lookup  i using three column part #, price, parts in stock. I  won't  to
lookup
part # and it wil show price and show parts in stock
find each of the items in an array and save result in another array28 Jun 2006 01:54 GMT2
There must be an easy solution to this.
I am working with an array of values and need to look up each value in
a worksheet and store the value of a cell 3 columns away in another
array.
prevent a special cell from being deleted28 Jun 2006 00:30 GMT1
The cell has the content "Do Not Delete"
How do I write an If statement to prevent this cell from being deleted
by a macro that deletes a row?
Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.