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 / New Users / June 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Concatinate worked but...11 Jun 2005 23:43 GMT2
I have joined the first name and last name of my sheet using:  =I17&" "&J17
But, when I go to export the sheet, it doesn't put anything in where the
forumula is for each row.
How do I turn the displayed names when exporting?
what three  features in word,excel and powerpoint have n common?11 Jun 2005 21:55 GMT1
I would like to know what three features do powerpoint, excel and microsoft
word have in common?
any signs or symbols they might have that would enhance the other two
programs.
Selecting from Drop-down11 Jun 2005 21:27 GMT2
have a drop down menu with six numbers 1, 2, 3, 4, 5, and 6. what I am
trying to do is that if I select 1, it should give me a list of
different numbers in the subsequent rows.....similarly for the other
numbers. for Example if I choose 3 in my drop down menu (A 7), if
password protected11 Jun 2005 20:46 GMT3
can I secure a sheet when it's a vlookup design?
I have 2 sheets... sheet 1 is for my vlookup formula, sheet 2 is where
all my data reside and it's hidden.
now. sheet 1 is interactive where-in users enter in an area code, hit
Vlookup with several different "Table_arrays"11 Jun 2005 20:17 GMT2
I am using a Vlookup and I would like to use several different
"table_arrays" to check.  The "table_arrays" are on different
worksheets but in the same workbook.  I tried using an "or" in  the
"table-array" but I got an error message.  Does anyone know how to
Positioning 2 User Forms11 Jun 2005 20:16 GMT3
I hope I explain this correctly - I have user form 1 which on opening fills
the monitor screen with everything in its correct place and working OK.
Within the same Workbook I have a small user form 2 which is opened by a
command button on user form 1. On opening that works ...
Sheet Navigation11 Jun 2005 19:57 GMT2
   I have written a macro the selects other sheets and performs some
actions.
   What i would like to do is return the user back to the original sheet
they started at. The start sheet can be different and have different names.
Entering Todays date in an excel spreadseet11 Jun 2005 19:54 GMT2
I have a need to automatically save the current date to a cell in an excel spreadsheet every time the sheet is saved.
Today() always returns the current date, so once I open the sheet on a new day I can no longer see the date the information was last updated, i.e. saved.
Any help ...
Confused, help with this line please!11 Jun 2005 17:50 GMT5
Range(Cells(9, 1), Cells(9, 6)).Delete Shift:=xlUp
works fine, but
Worksheets(3).Range(Cells(9, 1), Cells(9, 6)).Delete Shift:=xlUp
gives a runtime error 1004 message.
How to validate and -if invalid- undo an entry?11 Jun 2005 17:32 GMT1
Private Sub Worksheet_Change(ByVal Target As Range)
If  (expression) Then
  Application.Undo
End Sub
check register with Excel11 Jun 2005 17:18 GMT3
looking to make check register with excel.  Trying to make column tha
will add and subtract with previous cell values(Ex: column C i
withdraw and cell E is deposits.)  Need to auto sum column F i
balance
How to delete a range and shift the rest up in Vbasic? 11 Jun 2005 16:19 GMT8
Selection.Delete Shift:=xlUp
This needs a selection first.
Formating Row and Col headers11 Jun 2005 16:13 GMT1
How can I change the format and color for Excel Row and Col.  Headers?
How to use variables for Range( ) ?11 Jun 2005 15:30 GMT1
Lets say my starting and ending coordinate variables are (x1,y1) and
(x2,y2).
I want to define a Range from (x1,y1) to (x2,y2). Range( ) accepts string
datatype so i cannot use variables in Range( ). I cannot use Cells ( ) cos
Macro To Copy Info From Sheet To Sheet11 Jun 2005 14:56 GMT6
I hope I explain this correctly. I have a xls file with (sheet 1) with all
my names and addresses. I have employees that will handle different
territories so I need to copy certain portions of (sheet 1) to other sheets
in the same workbook. What I would like it to do, is (sheet ...
 
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.