| Thread | Last Post | Replies |
|
| Concatinate worked but... | 11 Jun 2005 23:43 GMT | 2 |
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 GMT | 1 |
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-down | 11 Jun 2005 21:27 GMT | 2 |
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 protected | 11 Jun 2005 20:46 GMT | 3 |
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 GMT | 2 |
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 Forms | 11 Jun 2005 20:16 GMT | 3 |
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 Navigation | 11 Jun 2005 19:57 GMT | 2 |
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 spreadseet | 11 Jun 2005 19:54 GMT | 2 |
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 GMT | 5 |
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 GMT | 1 |
Private Sub Worksheet_Change(ByVal Target As Range) If (expression) Then Application.Undo End Sub
|
| check register with Excel | 11 Jun 2005 17:18 GMT | 3 |
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 GMT | 8 |
Selection.Delete Shift:=xlUp This needs a selection first.
|
| Formating Row and Col headers | 11 Jun 2005 16:13 GMT | 1 |
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 GMT | 1 |
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 Sheet | 11 Jun 2005 14:56 GMT | 6 |
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 ...
|