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 / April 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Copy A Named Range To a Different Sheet13 Apr 2008 04:50 GMT4
I have 2 sheets: "Input" and "Budget".
The source list is a named range called "NameSource" (D3:D839) which
is the list that the new names are being added.  
Special problem: the names are not in any particular order and they
test if a value is in a range of values13 Apr 2008 04:23 GMT1
I am trying to write a formula that tests a cell value to see if it matches
values in a range of values and returns either true or false.   Any help
would be greatly appreciated.
Josh
Checking to see if file already open13 Apr 2008 03:55 GMT1
I've already posted this on Excel Tip, but no answer.
Link:  http://www.excelforum.com/showthread.php?p=1905267#post1905267
This routine is used to open another Excel File in a SEPERATE INSTANCE of
Excel.
Retreive a variable12 Apr 2008 21:43 GMT5
Is it possible for my  UserForm code to retrieve a variable declared and
set in the main procedure?
   I am testing to see if the code is run on my computer or not. I already
have this Boolean value set in the main procedure but I do not see how to
ComboBox12 Apr 2008 20:36 GMT2
I'm trying to select the entire text in a combobox when the combbox is
dbl clicked.
The sample I'm using at:
http://www.contextures.com/xlDataVal10.html
MS EXCEL (NEED HELP)12 Apr 2008 20:00 GMT4
We have a very extensive application that requires the use of Ms excel to
run. We are getting ready to launch our product to the public but we are very
concerned about protecting our worksheets and projects etc.  We have very
extensive passwords and scrambling etc.  We have found ...
Excel VBA macro to encrypt a Workbook or Spreadsheet12 Apr 2008 19:58 GMT3
I've created a button in a spreadsheet that, when clicked, will encrypt and
compress a Workbook using IZArc's command line tool. Unfortunately, this
requires downloading and installing IZArc software. I would rather use an
Excel built-in function that would encrypt and compress a ...
Application wait question12 Apr 2008 19:21 GMT4
I'm having some issues with pausing a macro to allow data to load.  I have a
table created from an imported web query, and my macro refreshes the query
and then makes some adjustments to the new data:  
Sub NewData()  
Decimal question in variable?12 Apr 2008 18:29 GMT1
I would like to know if it exists a function to round up or down a three or
more decimal at only two,
I am not talking about the content of a cell but at the content of a variable
Ex: B = 13.34567
Update numerous comboxes at once12 Apr 2008 18:04 GMT4
I can update the rowsource of an individual combobox programatically
using the below;
ComboBox2.RowSource = "details!g4:g24"
however i need to do a lot at a time, looping through them one by one.
Conditional Format / VLookup12 Apr 2008 17:40 GMT5
What I would like to do is have a conditional format which looks at the
value of the cell then find the matching value on the WorkShifts Monday
worksheet (that value would be found in column A and then when it finds that
look at Column U. If the value in column U is "Large" I ...
nse website query12 Apr 2008 17:17 GMT2
please see the following link
http://www.nseindia.com/content/equities/eq_scriphistdata.htm
the site generates historical data of price and volume based on various
inputs as follows: scrip code, start date and end date. suppose we choose
Autofill problem12 Apr 2008 17:09 GMT2
I've got a macro that will take the value in the previous cell and
extend the series to the adjacent cells.  Unfortunately, it isn't
acting in quite the way I had planned.  The number of cells to be
filled is variable.  For instance, a year will be entered into cell
Hide menus etc in Excel 200712 Apr 2008 16:59 GMT5
How can I convert the following to hide the menus and ribbon in Excel
2007?
  **********
  Dim Wksht As Worksheet
Excel VBA macro to send email attachment from default email client12 Apr 2008 15:54 GMT2
I would need help to create a VBA macro that will send an email attachment
(a .zip file which contains an encrypted Workbook) using the default email
client (not necessarily Outlook). I would need to be able to specify the
"To:" email address and the "Subject:". I don't need to ...
 
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.