Ashish,
Thank you so much for responding but let me ask you this. Can formula be
twiked that everything between x.51 and x.99 in C1 is rounded to x.97 and
everything between x.01 to x.49 in C1 is rounded to x.47.
Your example shows:
9.99 75% 2.50 2.47 25.99 60% 10.40 10.97 29.99 30% 20.99
Hi David,
Thanks for your feedback and evaluation. I've corrected and posted the
solution, please check this link again to see the changes:
http://www.excelitems.com/2009/03/ceiling-and-floor-function.html
For more tips, tricks, downloads and problem solutions: visit --
Hi Roopesh,
Here is the code.
I am assuming that whenever a workbook is opened, the default sheet as data,
that with Header row. If there is no header row, then you just need to add
comment ' before a line.
ub mymacro()
Dim path As String
Dim i As Integer
Application.DisplayAlerts = False
Hi Roopesh,
Here is the code.
I am assuming that whenever a workbook is opened, the default sheet as
data, that with Header row. If there is no header row, then you just need to
add comment ' before a line.
sub mymacro()
Dim path As String
Dim i As Integer
Application.DisplayAlerts =
Hi,
This is the code I use for this.
Suppose you are looking for the next available row in column A
A = 1
Do Until Cells(A, 1) =
A = A + 1
Loop
When this section finishes, the next available cell: Cells(A, 1)
If your data is contiguous, you can use:
A = WorksheetFunction.CountA(A:A) + 1
Dear All,
Please help me.
Attaching herewith the downloaded data. I want to do just text to column.
But when I do this, the data after special character (Square) has been
deleted.
--
Thanks Regards,
Lavprasad Kori
MIS Executive - Water
Tel. 022 - 39833428
I found this example online. It actually refreshed every 15 seconds
continuously, but if you press the F12 key, it will stop the refresh
(that way you do not have to ^Break the code)
http://forums.pcworld.co.nz/showthread.php?t=54801
On Feb 28, 2:17 am, himu himadri@gmail.com wrote:
Hi
You know how you can drag a highlighted cell to copy its value across
or down? Well is there a way to turn off the feature that
automatically increments the value?
--~--~-~--~~~---~--~~
Hi Ashish,
I tried the code, but it is not working the way it should.. I have
uploaded a file here
http://groups.google.com/group/excel-macros/web/VBA%20form%20auto%20resizing%20%282%29.xls
Infact the number of sets can increase. So what ultimately is desired
that formwidth and Formheight
You can do it by nesting your IF statements:
=IF(H3=TRUE,TRUE,IF(B2B3,TRUE,FALSE))
Basically, you're saying IF(condition1, true, if condition1 false then if(
condition2, true, false))
You can do this several times although the formulas tend to get complicated.
IIRC the limit is 9 nested IF
Hi Angus,
Try this
=IF(OR(H3=TRUE,B2B3),TRUE,FALSE)
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Hi ccraif,
Some check points for you, please try and revert back to us.
1. Try this(below) - Focus on _ (Underscore) in the end preceded by a
spacebar.
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=
_
B3 Production Input!R1C1:R111C7, Version:=xlPivotTableVersion12). _
*Hi All,*
**
*i am generating Excel from POI Jar , when i am generating Excel i am
getting *
*maximum number of fonts have been exceeded error Can you please give
some solution. *
**
*its urgent.*
**
**
*Regards,*
*S Jacob *
--~--~-~--~~~---~--~~
Here is the file. named VBA form auto resizing.xls (2)
http://groups.google.co.in/group/excel-macros/files?sort=date
Kanwaljit
On Mar 6, 12:05 am, kanwal_no1 kanwal...@gmail.com wrote:
Hi Ashish,
I tried the code, but it is not working the way it should.. I have
uploaded a file
Hi
Can anyone send me the VBA Tutorial as I am new to VBA. I can work with excel
but I don't know VB functions/codes. I want to study VBA
Thanks in advance
Muthu Pandian
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
15 matches
Mail list logo