Please how can i put a file attached?
i have a solution to this probleme !
Thank's
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
Hello Andy and Deepak,
I want to find a specific headder and delete entire row.
For example i have a headder called Name in A10 row and below name headder
there are many names entered,
what macro should do is, it should find headder Name and delete entire
Column A:A or A10 to A65000.
In other
Try this:
Sub Tisp2Core()
Dim lngLastRow As Long, i As Long
Application.Goto Reference:=R6500C2
lngLastRow = Selection.End(xlUp).Row
Do
If UCase(Range(B4).Offset(i, 0).Value) = TISP And _
UCase(Range(B4).Offset(i, 3).Value) = CORE Then
No Sir,
It did not go below 6500 lines.It stoped in that cell.
I have data till end of the sheet.
Plz help
On Wed, Nov 18, 2009 at 8:25 PM, PMann philip...@gmail.com wrote:
Try this:
Sub Tisp2Core()
Dim lngLastRow As Long, i As Long
Application.Goto Reference:=R6500C2
lngLastRow
Hello Team,
I need a macro to change Column B from Tisp to PAT if the Column D is Core
Regards,
VR
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
Hi,
As per my understanding I have attached a solution of it. Please find the
attached file.
Regards,
Deepak Rai
On Tue, Nov 17, 2009 at 6:45 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
I need a macro to change Column B from Tisp to PAT if the Column D is Core
Regards,
VR
Hi VR,
Please use the following code:
Sub TispPAT()
'Macro created by Aindril De(Andy)
'Shortcut Ctrl + Shift + p
Dim CurCell As Object
Dim i As Integer
i = 4
For Each CurCell In Range(B4:B11)
Range(B i).Activate
If ActiveCell.Value = Tisp And
HI Deepak,
Great!!! It worked fine.
I have another requirement like deleting column based on given headder.
Is that possible?
Plz find attached.
Hope it should not be difficult for you.
Thanks in advance for your help.
Regards,
VR
On Tue, Nov 17, 2009 at 8:08 PM, Deepak Rai daksh1...@gmail.com
Thanks Andy. Plz help me on other file about deleting columns
On Tue, Nov 17, 2009 at 8:46 PM, Aindril De aind...@gmail.com wrote:
Hi VR,
Please use the following code:
Sub TispPAT()
'Macro created by Aindril De(Andy)
'Shortcut Ctrl + Shift + p
Dim CurCell As Object
Dim i As
Hi,
Thanks if my solution helped u, for this problem I need detailed
explanation of your problem.
Regards,
Deepak Rai
On Tue, Nov 17, 2009 at 8:56 PM, vinod rao vinod.ma...@gmail.com wrote:
Thanks Andy. Plz help me on other file about deleting columns
On Tue, Nov 17, 2009 at 8:46 PM,
10 matches
Mail list logo