Dear Excel Experts!!!.
I use very advanced EXCEL in my day to day job. But, I am totally
ignorant of VBA/Macros.
If some suggests me the structured way of learning VBA/Macros, it would be
a great help to me. I can use my time for fruitful analysis jobs in a more
productive way.
thanks & reg
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/
--~--~-~--~~--
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 wrote:
> Hi Ashish,
>
> I tried the code, but it is not working the way it should.. I have
> uploaded a file
> herehttp://gro
*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 *
--~--~-~--~~~---~--~~
-
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 Melih,
1. Select the cell that contains the formula or Value that you
want to fill into adjacent cells.(Whether UP or DOWN)
2. Drag the fill handle (fill handle:
Hi Angus,
Try this
=IF(OR(H3=TRUE,B2
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Auth
You can do it by nesting your IF statements:
=IF(H3=TRUE,TRUE,IF(B2mailto:excel-mac...@googlegroups.com]
On Behalf Of Angus
Sent: Thursday, March 05, 2009 11:15 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Want to write something like this - =IF(H3=TRUE OR
B2 < B3, TRUE)
Hello
I wa
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 are
Hello
I want an if which checks two conditions
If it was in C++ would look like this:
if(H3 == "TRUE") || (B2 < B3)
//update cell contents to "TRUE"
The || is like an OR - ie can be this or that.
Hopw can I do this in Excel VBA?
Angus
--~--~-~--~~~---~--~
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?
--~--~-~--~~~---~--~~
---
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 wrote:
> Hi All,
>
> I am trying
I have recorded a macro using Excel 2007 macro recorder. This macro
selects a certain range, and then creates and places a Pivot Table on
a different sheet. I figured using record it would work, but with out
any changes to the macro, I get a Runtime Error 5 (Invalid Procedure
or Argument). I shou
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
--~--~-~--~~--
> 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.Di
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
Ap
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
Could you share the workbooks your team members are using?
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we
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 -->
http://www.excelitems.c
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 20.
20 matches
Mail list logo
