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 / February 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how can I get into a cell that it"s protected with a password26 Feb 2007 01:36 GMT1
I need to open a protected work sheet that I have protected years ago and
have forgotten the password that I have used.
Can somebody please help me ASAP
Thank you
match vs find question25 Feb 2007 23:16 GMT4
right now i'm using find to search a row of values for an item, if it find it, i
use the rngfound row to enter some data below. if it doesn't find it, it adds an
item to the range.
i could use application.match to return the position, too, so i'm just wondering
Access to user-created menu25 Feb 2007 23:09 GMT9
Excel XP & Win XP
   I have a user created menu that I built with John Walkenbach's easy menu
maker.  The menu has about 30 items.  Of course, the menu is available to
any open workbook besides the also-open intended workbook.
Fill cells with names from list25 Feb 2007 22:40 GMT5
XL2000
I have a workbook I want to use in multiple counties.
I have a list of student names in a named range "Students" in ColAD
ColA contains each students name followed by a list of classes followed by
Grid Selection25 Feb 2007 22:32 GMT2
Is it possible to change the colour from black to cell colour, making
the grid invisible?
Thanks - Kirk
Cell References25 Feb 2007 21:44 GMT1
Ok I am trying to create a cell that displays an IP address based on a
starting address on the front page.  The address that I start this off of is
actually 4 cells (one for each octet) which I am combining together.  It
works fine, but my problem is that if I change one of the ...
Help with vlookup with certain cell change25 Feb 2007 21:24 GMT4
I'm a newbie with Excel VBA so please beare with me.  I'm developing a
daily logging spreadsheet on all the employee's attendance.  This
spreadsheet comprises of 2 sheets;"incidents" and "name".  First being the
logging sheet and the later contains a list of employee's name.
worksheet_change colour of a row on change of cell25 Feb 2007 20:52 GMT6
Hi - can anyone help please
I've tried Subject: RE: More than 6 conditional Formats....VBA Coding Advise
please   1/5/2006 7:08 PM PST
By:    JulieD  In:    microsoft.public.excel.newusers
Outlook attachments25 Feb 2007 20:42 GMT2
Each Monday I run a VBA generated office inventory report in Excel.  Each
employee's inventory is output to a separate worksheet tabbed with his or
her name.  The VBA code includes a procedure that attaches each employee's
report to an Outlook e-mail.  I've been running this program ...
Putting the name of a worksheet in a cell25 Feb 2007 18:54 GMT2
What code do i need ?
Thanxxxxxxxxxxx
Luc
--------------------------------------------------------------------------------
Can I start the text import wizard automatically?25 Feb 2007 18:47 GMT4
I have a file format which is actually CSV but has my own extension. I`ve
manually registered it in the windows registry to be opened by MS Excel. If I
open these files from Windows Explorer (not from Excel "Open file" dialog) I
need to start Text import wizard manually to ...
Macro to move a cell to centre screen25 Feb 2007 17:29 GMT2
I want to write a simple macro that will make a given cell (defined by the
contents of two other cells - i.e. row number and column number) move to
the centre of the screen (approximately).
Is there a simple way in which I can do this please? I can't find a function
How to reach Application Objects in Events?25 Feb 2007 17:27 GMT3
Need to perform Range("A:A").Find operation in
ActiveSheet.Button1.OnClick event handler in module (not in a class!).
Button - member  of the sheet. But, Application members seems to be
not visible for events until they specially declared (if I call event
iterate through chart series collection25 Feb 2007 15:30 GMT8
sorry to be bugging the group so mych about charts but Im getting my
butt kicked.  The new problem is this:
Building a column chart and needing to add the series x axis labels
which are set in VBA with
Pass a string to an address25 Feb 2007 14:18 GMT3
In this snip I need to pass a range.address of a range to a string,
manipulate the strig and then pass it back to the range.address.  the
first two steps are fine but I get an error "assignment to constant
not permited" when I try to pass the string back to the address.
 
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.