Thank you Dave,
The code you suggested worked fine. Although i discovered that the user can
still open the file with macro disabled and change the cell content, save
and reopen it. now I wish when the workbook is open, it checks the value of
sheet1(D3) if equal to "BRIDGESTONE COMPANY INC." if ye
Hi Sundarvelan,
Can you send a sample excel, so that we can give you perfect solution.
Regards,
Swapnil.
On Mon, Apr 26, 2010 at 12:47 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I need a help to delete the entire row if a single/particular column
> contain a word "B" as the starting letter (S
Dear All,
Please help me for excel condition formula's, pls send formula with example
...pls it's a urgent.
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_
Thank you all for the solutions provided.
Would it possible to locate the cell that has been used in the formula
and highlight that cell? Eg:
=Sum(A4,a7,a9), when we run the macro, A4,A7,A9 should get highlighted
Harry
On Apr 26, 10:28 am, rf1234 rf1234 wrote:
> Hello Dear,
> Attached Workbook
Hello Friends,
Any one please correct the error
Dim fcount As Range
With ActiveSheet
Set fcount = Worksheets("N136D").Cells.Find(what:="COUNT",
MatchCase:=False).Select
Range(Chr((ActiveCell.Column) + 64) & ":" &
Chr((ActiveCell.Column) + 64)).Select
Selection.Delete
On Er
Hi,
Try this code instead:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
If Sheets("Sheet1").Range("D3") <> "BRIDGESTONE COMPANY INC." Then
MsgBox " FILE WILL BE CLOSED!!", vbOKOnly + vbExclamation
MsgBox "Please contact EDP "
T
Resending since I forgot the subject... sorry!
Hi, I need some help. I have a long list of customers, and I need to loop
through it and extract part of the data. I can not use PivotTables, I need VBA
on this. Please find attached a sample model of input/output. This should not
be too com
Hi, I need some help. I have a long list of customers, and I need to loop
through it and extract part of the data. I can not use PivotTables, I need VBA
on this. Please find attached a sample model of input/output. This should not
be too complex but I am not very familiar with arrays and loops.
Hi Sudhir,
Try this,,,
hope u r talking abut grouping and ungrouping
Rows("1:2").Select
Selection.Rows.Group
--- On Sat, 24/4/10, sudhir wrote:
From: sudhir
Subject: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide
the subheading in excel
To: "MS EXCEL AND VBA M
Dear friends,
I have two excel sheets, both are having same format, and contain huge
amount of data.
now i want to compare them, old one with the new one. and i want to
find out which data is deleted, which one is added, and which one is
changed. plz help me.
--
--
hi,
thanx dear
On Mon, Apr 26, 2010 at 10:56 AM, Ahmedhonest wrote:
> Dear Team,
>
> Felt happy to see with your suggestions and thanks a lot i got what i was
> looking for.
>
> A Special one is to *Mr. Vikas Chauhan *appreciate you help and support
> the formula was great it solved exactly what
Vinu,
I think the following statement may work for you
*ActiveWorkbook.SaveAs Filename:="PAth of the file", _
FileFormat:=xlNormal, Password:="A", WriteResPassword:="A", _
ReadOnlyRecommended:=False, CreateBackup:=False
*
Group: Guys i think i am not pretty sure about this code, a
hi harpreet ji ,
thank u very much , thats the thing i want
--
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.com,
--
--
Some important links for exce
Hello Dear,
Please send mail with proper subject line and message.Here We are
unable to understand your problem.
we can help better when we know your problem.
On Mon, Apr 26, 2010 at 10:44 AM, ram kumar.m wrote:
>
>
> --
> Thanks and Regard
> ramkumar.m
> HAVE A NICE DAY FRNDS:)
>
> --
>
Hello Group,
I need a macro to fill the data in the attached sheet. What I want is to
fill the vacant cells below cell A4 with the value present in cell A4 till
the next valued cell . i.e. as per the attached sheet, I want the value in
A4 to be copied till cell A15, then the value in A16 to be
Dear group,
i try to catch the user's action via worksheet change event. My worksheet
has a value at cell D6 that i would like to remain constant and if that
value is change by user the workbook is closed.
My problem now is, even if this values are unchanged but if any other range
of cell is del
Hi Harmeet Singh,
Thanks for your reply, It works for Month criteria, But i want it for
Days criteria , for example if i have 3 entries fro 2nd Jan it shoudl
consider as 1, for 3rd jan 2 entries then it should consider it as 1,
So total 2 main entries for Jan.
Hope i am clear in explaning the pro
Hello Sundarvelan,
I suggest you try first the subtotal function of excel. On the menu click
on data then sub total, follow as prompted. It should give you what you
need.
On Sun, Apr 25, 2010 at 7:49 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I need a macro to sort the below excel by client a
Hi Friends,
I need a help to delete the entire row if a single/particular column contain
a word "B" as the starting letter (ST-CD is the header of that column).
Using VBA Code.
Thanks,
N.Sundarvelan
--
--
Some impor
Dear Team,
Felt happy to see with your suggestions and thanks a lot i got what i was
looking for.
A Special one is to *Mr. Vikas Chauhan *appreciate you help and support the
formula was great it solved exactly what i was looking for, once again
thanks to all who suggested me.
Regards
Ahmed Bawaz
Hi Friends,
I need a help to delete the entire row if a single/particular column contain
a word *"B"* as the starting letter (ST-CD is the header of that column).
Using VBA Code.
Thanks,
N.Sundarvelan
--
--
Some imp
--
Thanks and Regard
ramkumar.m
HAVE A NICE DAY FRNDS:)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ h
I have spreadsheets of imported data from another program, so I have
no control over the initial formatting of the data. The program puts
out data but does not fill in every cell if it is the same data as the
cell above it. I am sorting the data several different ways, and
having blank cells is t
updating my previous code
Sub ListOfWorkWeekDate()
Dim dtLastSunday As Date
Dim i As Byte
dtLastSunday = Date - Weekday(Date) + 1
For i = 1 To 6
ActiveCell(i, 1).NumberFormat = ", dd mmm "
ActiveCell(i, 1) = dtLastSunday + i
Next
End Sub
On Apr 23, 3:38 pm, S
The below procedure will create a list of current Work-Week-Date
in one-ColumnRange (6 cells) starting at the active cell
Sub ListOfWorkWeekDate()
Dim dtLastSunday As Date
Dim i As Byte
dtLastSunday = Date - Weekday(Date) + 1
For i = 1 To 6
ActiveCell(i, 1) = dtLastSunday + i
Hello Dear,
Following Is The Discription About Sas
SAS Computing
•SAS (software), an integrated software suite produced by SAS Institute Inc.
•Secure Attention Sequence or secure attention key, a method to invoke
a computer operating system's attention, usually signaling it to show
the log on scre
Hello Dear,
Please let us know,which trading software you are using.
We can help better,when we understand your problem.
On Sat, Apr 24, 2010 at 10:16 PM, nitz gupta wrote:
> Dear Friends,
>
> is there a way with which i can convert my excel file to interact with my
> trading software
27 matches
Mail list logo