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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
SharePoint Versions21 May 2008 20:12 GMT1
Can someone tell me if there's a way I can access versions of files in a
SharePoint Document library?
Dependent Validation List21 May 2008 19:38 GMT2
A worksheet contains data as follows:
Column A   ColumnnB
Country1       $B$24:$B$30
Country2       $B$9:$B$18
Delete last sheet in workbook21 May 2008 19:37 GMT13
First, thank you for looking at this post.
I have a macro that takes the cell comments from other sheets and creates a
summary sheet showing all of them. I'm constantly adding to the main sheets
and running this macro but every time I do I have to first delete the sheet
VALIDATION FUNCTION HELP21 May 2008 19:27 GMT1
How can I use validation to stop users from entering the following
characters?:  / \ : * ? " < > |
vba - Select Used Range minus the top header21 May 2008 19:19 GMT4
I am using "ActiveSheet.UsedRange.Select" to select the used range and
that's great. However, I can't figure out how to ignore the first row
of data, because it's a header. I'm still searching the boards but I
haven't seen anyone ask this question.
Conditional Formating21 May 2008 19:16 GMT1
how can I have a cell change color if a cell within a group has the value of
"1" and then revert back it the value changes.
A3 (Cell to change color)
B1:E10 need to see if any cell returnes "1" if so need to change A3 to a color
sort entire range with exception of last row21 May 2008 19:15 GMT2
is there a snipet of vba code that could be used to sort 3 columns of
variable length with the exception of the last row (last row used for totals).
The column range is a:k (rows, again, are variable).  I am looking to sort
in this order:
import multiple CSV files into one Excel file21 May 2008 18:33 GMT3
I have roughly around 2000 CSV files (each file is in the range of
49bytes-3MB, a total of 35MB).
I would like to import each CSV file to an individual sheet in Excel
workbook using Perl OLE.
Get templates files and copy data to it21 May 2008 18:32 GMT22
I have a working sheet contains 15 columns and undetermine rows of data. I
have workbooks saved as group name, eg. "ABC Ltd" in a folder named under
group, eg. "ABC Ltd". These workbooks consist of about 5 -10 sheet templates
and are named under "group person "eg. "ABC John"
with a macro open a workbook without the Auto_Open running21 May 2008 18:29 GMT3
I wish to open a workbook that has Auto_Open installed.  I merely want to
extract information from a specific cell.  My proglem is that the workbook
when opend will run Auto Open.  Is there a way to prevent the Auto_Open macro
from execuiting?
2nd TRY: Up from 2003 to 2007; code now throws error creating     object??21 May 2008 18:24 GMT4
I've been beating on this for two days.  I posted earlier in
excel.programming (http://groups.google.com/group/
microsoft.public.excel.programming/browse_thread/thread/
fb2e4df1284c42a2?hl=en#), but I've gotten more info since then and
copy row based on match and multiple criteria21 May 2008 18:22 GMT1
I need a formula or function that would look at a value in a cell,
compare it to a whole column on another sheet
If a match exists then I need the code to look say 10 columns further
along in the same row at the cell value.
Processing a Message Box w/in a Macro21 May 2008 18:17 GMT1
I could use help with the following;
I have a macro and when I run it, it displays a message box offering
three choices, "OK, Cancel and Help".  When I choose "OK", the macro
continues to run to a successful conclusion.  I want to process this
CLEAR FIELD TEXT ON CLICK?21 May 2008 17:54 GMT3
Hi.  I have a form that I'd like to automatically clear when it's
clicked for text input.  Is this possible in excel?
Goto ("A1") in non active sheet21 May 2008 17:53 GMT3
Hello all, i have a number of sheets that i am putting data in, but each
sheet is not active when i do that. The sheet name is variable "s", is it
possible to select "A1" on these sheets without activating them ?
I have tried
 
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.