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
Multiple Modules in the same workbook?26 Jun 2006 08:51 GMT6
Is there problems with having more than one module in a workbook.
I've created a second module because I need to 'Sub DeleteModule()' for
one of them because it contains the 'Sub Auto_Open()' which I don't want
to carry over when I SaveAs.
Macros using Add-Ins26 Jun 2006 08:23 GMT1
I have a problem with the EasyFilter Add-in (by Ron deBruin MVP) and its
use in a Macro which I cannot seem to fix - or even find a solution to
on the Internet.  
I have just started my journey with Macros in order to help me clean
Parsing Characters - Bug ???26 Jun 2006 07:59 GMT10
I have a complex macro that parses characters in the active cell and makes
changes to the worksheet. However, if the macro is run after opening the wb
before any manual cell entry is made (as opposed to clearing contents or
pasting etc.) then the macro runs very slowly. This is ...
AutoFilter Data26 Jun 2006 06:28 GMT2
  I have a C# code that use an excel appliction. In my code, I use the
AutoFilter in a certain range. My question is how could I get the
return values of the autofilter and manipulate/scan the return data.
Below is my code taken in a certain procedure:
macro to search and list data26 Jun 2006 06:19 GMT2
is their a macro that will look threw a page of data and report on another
page a list of results based on information in a percific col
colums A to I contain data
want to search col G and do a report on every event that does not contain
Help with blinking text26 Jun 2006 05:11 GMT2
I am current using the blink text code found at www.cpearson.com but I would
like to make it so that if I were to change a value in a cell that it would
then start blinking.  So for example:  If cell A1 changes to 80% or lower
then make A1 start blinking.  Also, I would like to ...
Create New WB with copy of Sheets 1 & 2 when sheets count reaches 10026 Jun 2006 04:52 GMT5
What i want to do is create a New workBook, when the number of worksheets reaches 100.
I have a button set up to create a new record(sheet) from a Template (Sheet1) in a workbook.
To save over sizing and increasing the chances of a file crash, i want to have the WB, if the create a ...
Desktop shortcut26 Jun 2006 04:38 GMT3
Is it possible to have the activeworkbook when it saves for the very first
time to automatically put a shortcut onto the desktop?
I can work out how to have the code activate for the first time, just not
how to get a shortcut to the desktop
Excel and Visual Basic26 Jun 2006 04:14 GMT2
Hello,
I am trying to create a command button in Microsoft Excel (Office 2000) that
enables me to reset the check box status for a worksheet from checked to
unchecked. The worksheet contains approximately 50 check boxes and is meant
Excel VBA Macro Running DOS Application !!26 Jun 2006 03:59 GMT11
Hello;
I would very much appreciate your expertise on how-to!
In myBook1.xls, I've a VBA macro, say, Sub myMacro (), which generates,
compiles, and saves a specially unformatted data file, say, myInputFile =
datestamp a comment into a cell26 Jun 2006 03:54 GMT1
Is it possible to have the date in which a comment is editted populate into
an actual cell?
Match in VBA26 Jun 2006 03:28 GMT7
I have some dates in column E (starting from 31-Jan-2005 to 31-Oct-09
-- 3 Month stretch)
If I put the following formula in my excel worksheet
=MATCH(TODAY()-1,$E$2:$E$21,1)
Procedure not running automatically...26 Jun 2006 03:21 GMT1
The 'Private Sub Workbook_BeforeClose()' isn't running automatically (or
at all for that matter).
I've got the code in a module of it's own("B4Close") along with the
'Sub CopyData1' procedure. But when I close the Workbook it doesn't
copy and insert entire row based on integer in column A26 Jun 2006 02:18 GMT8
I have a spreadsheet that contains data as follows;
3  rgf rhh
2  xyz abc
4  ejerr
Is it possible to join columns where there is a match?25 Jun 2006 22:59 GMT1
Any guidence here will be much appreciated.
It it possible to have one worksheet with unique values and anothe
worksheet with values realated to those unique values in a secon
worksheet, and have a routine where either import the second workshee
 
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.