the code below could work.
ActiveWorkbook.SaveAs C:\ron.xlsm, fileformat:=52
the fileformat value could be changed as follows
*51* = xlOpenXMLWorkbook (without macro's in 2007, xlsx)
*52* = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007, xlsm)
*50* = xlExcel12 (Excel Binary
Hi All,
I want to know, if there is any other option, i.e., other than Track
Changes. I want to know in my excel sheet, if someone does any changes in
any column/Row/Cell for e.g., Adding one row in between of existing rows,
changing the values of cells.
There is a restriction in Track Changes,
Can anyone tell me a short cut key for 'trace dependents'??
The shortcut key for 'trace precedents' is cntrl + [ for those who
don't know.
Look forward for a shortcut.. :-)
Thanks and regards,
Jaydeep
--~--~-~--~~~---~--~~
hi,
try this macro
Sub RemoveChar()
Dim StrAdd As String
StrAdd = Range(A5000).End(xlUp).Address
Range(A1).Select
While ActiveCell.Address StrAdd
If InStr(1, ActiveCell.Value, *) 0 Then
ActiveCell.Value = Right(ActiveCell.Value, Len
(ActiveCell.Value) - 1)
End If
Just starting to learn macros.
I have a cell in Sheet1 that performs a calculation. Either by means
of a function in a cell, or with a macro, create a conditional that
will insert the calculated data into a cell in Sheet2 or Sheet3.
Example:
Calculation performed in Sheet1 A1.
Thanks vivek for your help. This is really very helpful.
Thanks Regards,
Ramkrishna T. Padhi
On 7/8/09, vivek agrawal vivek.agrawa...@gmail.com wrote:
Hello RamKishna,
Please find attached the xls file with working macro...
You just need to select the range containing the sheet names
Hi,
If you are using office 2007 you can use countifs function else u can use
formula like below
=COUNTIF(A2:A8,mumbai)+COUNTIF(A2:A8,delhi)
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of amresh kumar
Sent: 09 July
Dear Amresh,
simple way is to calculate seprately for Mumbai Delhi then add it
COUNTIF(A1:A8,=Mumbai)
COUNTIF(A1:A8,=Delhi)
On Thu, Jul 9, 2009 at 1:05 PM, amresh kumar amreshkushw...@gmail.comwrote:
Hi Team,
i want learn more of countif function.
example
City Delhi
Hello Pooja
To track changes on a new work sheet kindly follow the steps given below.
1. Activate the Track Changes Feature.
2. Assume that the changes have been made and saved in the work book. After
changes have been made to the workbook, you can automatically create a new
worksheet that lists
How about the following
=COUNTIF(A1:A8,A6) + COUNTIF(A1:A8,A7)
Akhilesh Kumar Karna
On Thu, Jul 9, 2009 at 4:35 PM, amresh kumar amreshkushw...@gmail.comwrote:
Hi Team,
i want learn more of countif function.
example
City Delhi Mumbai Maharashtra
Delhi Mumbai Delhi
Hello Guys,
I have a problem and my mind is blocked so need your help here- I have 4
cells one below the other and the values specified in each cell is as
follows
cell A - 65
cell B - 15
cell C - 3
cell D - 17
Now the total of all the cell is 100. If I change the value of any cell say
I
Then, let's use macro :
Sub Test()
Dim X As Single
X = 10
If [Sheet1!A1] X Then
[Sheet3!A1] =
[Sheet2!A1] = [Sheet1!A1]
Else
[Sheet2!A1] =
[Sheet3!A1] = [Sheet1!A1]
End If
End Sub
[Sheet1!A1] is equivalent to Sheets(Sheet1).Range(A1)
lol... i tried that before and it didnt happen.. and after u replied
its working... thanks a lot... coz i assumed there must be another
shortcut...
again thanks...
On Jul 9, 11:54 am, vivek agrawal vivek.agrawa...@gmail.com wrote:
CTRL + ] - for trace dependents use the closing bracket
Dear members,
It is my pleasure to inform you that the prize of June month goes to
Mr. Upendra Singh who was the winner of week 26. The prize is 200
rupees or 4$. The winner of the month is selected from the weekly
winners of the month. The Weekly winners of June is as follows :
1) Week # 24 :
Thanks a lot Danial
I had almost bang my head on the wall in search of this!
This forum Rocks!
Can you let me know what for 'Ctrl+Shift+Enter' is used for.
Thanks again!
Kunal
On Jul 9, 4:34 pm, Daniel dcolarde...@free.fr wrote:
Hi,
Array formulas (valídate with Ctrl+Shift+Enter).
In
Array formulas are used to deal with ranges of cells:
If you have a range of cells, let's say A1:A10, each with a value of 1,
let's try to add cells equal to 1 :
=SUM((A1:A10=1)*1)
Will give a result of 1 (in fact only the first cell is considered).
If you enter the same formula with
Hi
Been racking my brains for a few days but simply seem to have blanked out. I
have an excel file with the following headers.
Product|Version|Status|Date|Executive|Company Name|Contact|
Note: All the rows under the headers can be repeated multiple times. Filter
is an obvious method to get
17 matches
Mail list logo