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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how to add18 Jan 2008 01:50 GMT1
I have a question on this userform.  It now loads nicely.  Thanks.
Is there a way to add a choice called all to the end of the list?
That way the user can select which name to print or select all.  In
the case of all
How come VBA if clause fails?18 Jan 2008 01:44 GMT6
I have the following subroutine. Why can't I see the passed-in Range's
Cells(x,y).Value?
Sub getDataInfo2(sRange As Range)
   Const maxr = 15
Count Sum Problem18 Jan 2008 01:18 GMT2
Long time reader, first time poster. Hope I can find some insights.
Using the following sample table I want to be able to count the number
of times, and when, a total of 40 is reached in the Qty column. And
then with the remaining amount begin the count to 40 again. For
Addin Issues18 Jan 2008 01:01 GMT8
I've gone through all the forum postings from across the internet and
have managed to piece this much together, but there are some issues
that are inconsistently popping up still...
What i'm attempting to create is an add-in for the department with
format cells so they do not resize18 Jan 2008 00:54 GMT1
I created a order form and I do not want sales as they are typing to have the
cells or form expand.  Freeze the cells at teh exact size they are now if the
test is longer they will have to put in a different info.
Example
Getting Chart "Cursor" information in Excel 200318 Jan 2008 00:47 GMT4
I thought I posted something along these lines yesterday, but ....
What I would like is for the user to hold the mouse over a point in a series
on a chart, and somehow signal me (Event) so I can find the corresponding row
in the series. If I could get the information in the ...
Protection on a sheet type thats new to me!18 Jan 2008 00:29 GMT2
On a sheetI came accross a form of protection that is new to me.
It's not the normal cell protection- I have unprotected the sheet. I can see
grid lines / scroll bar etc. I can see the row numbers- but it won't let me
click on a cell!?
Converstion of Complex Word VBA macro to Excel Macro18 Jan 2008 00:21 GMT1
I'm looking for someone who is familiar with Word and Excel to convert
a very complex Word VBA macro to be able to function in Excel.
default fill color18 Jan 2008 00:19 GMT5
is there a way to change teh default fill color for highlighting from the
default yellow to say teh light gray color so when they come in they are
easily able to highlight?
Cell Content17 Jan 2008 23:51 GMT5
I am trying to use a Macro to sort through a table of numeric values
and modify the values based on a series of If statements.  Can someone
tell me if the contents of a cell can be modified with a Macro, other
than simple Copy/Cut/Paste funstion?
Pivot tables - how to hide the total row?17 Jan 2008 23:50 GMT3
I setup a pivot table programmatic.
But how can I hide the most right total row?
I have found a checkbox "Totals for rows / columns" in the TableOptions
Dialog.
Linking rows on multiple worksheets17 Jan 2008 23:15 GMT1
I have a database that uses multipe worksheets to store data entered from a
userform I created.  On each worksheet the first 4 columns are the same but
the rest are different, what I want to know is if it is possible to make it
so that if I were to move a row in worksheet 1 from ...
New user and need help17 Jan 2008 23:02 GMT1
Here is what I need to do I have been working on a sales sheet that will
track the sales via a won loss ratio. Now what I have been trying to do is to
take all of the information from the "activity" sheet and copy or perfer move
it to a sheet based as "lost" or "Won" drop down ...
UDF and dynamic range17 Jan 2008 22:01 GMT2
I have a function I built in which a couple of the inputs require a range...
I would like to have that range be dynamic so that sometimes it select 4
dates or sometimes only 3...   So I tried to put this in for my function
(I16:OFFSET($I$16,H15-1,0))... but that doesn't work.  If ...
Skipping empty cells for a Range object?17 Jan 2008 22:00 GMT1
In VBA..
Is it possible to set a Range object to skip empty cels? IOW, if I
copy A1:A10, and A5 is empty, and transpose them on B20, I want to
skip A5; I did SkipBlanks:=True and it still pasted the blank cells.
 
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.