Thank you for the response. Unfortunately, the data can't be sorted. It needs
to stay in the order entered.
From: "Kishan Reddy, K"
To: MS EXCEL AND VBA MACROS
Sent: Fri, September 3, 2010 10:56:47 PM
Subject: $$Excel-Macros$$ Re: Ned Maxif
Sort the data (
Hello
I am enabling the track changes option in Excel 2007 (Review > Track
changes > Highlight changes).
The option allows to track the changes made inside the cells but when
I try to edit the text inside the text box, excel is not allowing to
make the change. Similarly it is not allowing to edit
You can hide a worksheet.
But you can not protect it with password a worksheet.
I can propose a turn around method.
You can protect your VBA Code using password.
1. Protect the VBA code with password.
2. Write code to Hide the sheet when the workbook is open & close.
3. Create a UserForm for ent
Sub CreateMoreSheets()
'-- by siti Vi / Jakarta, Sept 4, 2010
Dim shtArr
Dim i As Integer
shtArr = InputBox("Type the Sheet's Name, separate by comma (,)")
shtArr = Split(shtArr, ",")
For i = 0 To UBound(shtArr)
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name =
Mr Santanu,
You can use this code
Sub AddWorksheet()
Dim SheetName As String
SheetName = InputBox("Enter the sheet Name")
Sheets.Add
ActiveSheet.Name = SheetName
End Sub
Regards,
Kishan Reddy, K
On Sep 3, 10:48 pm, santanu_ca wrote:
> Hi
> I want to insert multiple sheet. Say
Sort the data (column A ascending & Column C Descending)
for example you are having data from A2 to C100
In sheet 2, column C use Vlookup function (in C2)
=vlookup(a2, $A$2:$C$100, 3, false)
Regards,
Kishan Redyd, K
On Sep 3, 10:48 pm, None wrote:
> I have a sheet that has 2 columns of data.
