VBA; Escaping a 'For Next' loop question
Fri, 29 Aug 2008 11:01:12 -0700 (PDT)
Hi,
I have some code which uses a For Next loop which works very well
with a very large set of 'Regular Expression' statements.
I'm sure when the code is run, it would be a bit quicker if it
could go back to 'For' when the value of 'valid' is True rather than
continue to the end of the statements to fin ...
|
Date Format
Fri, 29 Aug 2008 09:56:01 -0700
I would like to convert a date that I've input from another program. When I
input it I get 'Aug-28-2008. I want it to just be a regular date - so it
would be *8/28/2008 if I were to select it in Format Cells.
It says that I have General as the Category selected. When I switch it to
Custom - nothing seems ...
|
change formula
Fri, 29 Aug 2008 09:32:01 -0700
Hi,
i need to be able to change the following formula:
=IF(OR(R5="25/08/2008",GM5="25/08/2008",GO5="25/08/2008","Before last 7
days","Last 7 days")
I want to let the user type into a cell so that the dates are all chnaged in
this formula
Thanks ...
|
how to fix starting point when counting rows?
Fri, 29 Aug 2008 08:08:11 -0700 (PDT)
is there a way to feed in the the starting cell to begin from when
counting the number of rows?
i can get the below to work in a macro
Dim countRows
countRows = Range("C9").End(xlDown).Row
but when i try to turn it into a function i cant figure out how to
give the starting cell as an argument
tks for ...
|
Bug in Excel 2007?
Fri, 29 Aug 2008 07:58:00 -0700
I have an Excel 2003 spreadsheet. It calculates several numbers in several
rows. The rows are shown in a simple bar graph. When I open it in Excel 2007,
and I adjust the input, all numbers in all rows are adjusted. But some of the
bars in the graph are not adjusted. The data in the bars are linked to cells
w ...
|
Show range of cells in a userform
Fri, 29 Aug 2008 07:04:08 -0700 (PDT)
Hi,
I would like to create a macro that shows a result in a userform (e.g.
a userform with tabs)
The result is a range of cells. How do I do this? The range has to be
active in the userform, so that I can tic of some rows if necessary.
Best regards,
HmH
...
|
Problem opening Txt file in excel 2007
Fri, 29 Aug 2008 09:43:54 -0400
Hi there,
We are trying to open .txt documents in excel like we used to in excel 2003,
but since upgrade to excel 2007 when we right click and try to open the txt
file with excel 2007 it always opens it in Notepad... Even when we
specifically choose Excel to open it with, it still opens it with notepad.. ...
|
|
|
specify dates in pivot table
Fri, 29 Aug 2008 05:29:00 -0700
Hi,
I have a column in a pivot table but i only want to see dates that are
either today or 7 days before today in the pivot table. Is there any way i
can do this?
thanks ...
|
how do u times hours by wages
Fri, 29 Aug 2008 05:21:01 -0700
im trying to create a roster on excel but i cant times the hours my staff
worked by there wage cost?
i have in b2 1:30AM
b3 4:30PM then in b5 the total is 3:00 the formula i used was =b3-b2+(b3<b2).
i want to times b5 by there wage cost $16.00
i dont know what else to do or if i have done that last formula wro ...
|
sorting base on date
Fri, 29 Aug 2008 18:52:13 +0800
how to sort based on a column of date that has either dd.mm.yyyy or
dd/mm/yyyy
...
|
