please paste this code in worksheet module
On Fri, Jun 6, 2014 at 7:36 PM, Eugene Bernard
wrote:
> Dear Ashish,
>
> Thanks for the code !!
>
> I just copied and tested, it is not giving expected result.
> What i am doing wrong. Please guide.
>
> Regards
> Eugene
>
>
> On Fri, Jun 6, 2014 at 10
Dear Ashish,
Thanks for the code !!
I just copied and tested, it is not giving expected result.
What i am doing wrong. Please guide.
Regards
Eugene
On Fri, Jun 6, 2014 at 10:13 AM, ashish koul wrote:
> Try this
> Private Sub Worksheet_Change(ByVal Target As Range)
> Dim arr, i As Long
> arr
Try this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim arr, i As Long
arr = Range("a2:d" & Range("a65356").End(xlUp).Row - 1)
'On Error GoTo err:
Application.EnableEvents = False
If Target.Count > 1 Then Application.Undo
If Target.Column = 2 Then
For i = LBound(arr) To UBound
Hello Rafael,
check the below sub and call the sub @ 'Need help here to do something with
the data collected from Sql Server
'
*
Private Sub WriteDate(rs As Recordset)
On Error GoTo ErrorMessage
Thank you so much for your quick help
On Monday, May 27, 2013 9:28:25 AM UTC-5, bé trần văn wrote:
> Cell D3:D9 and :D24 to enter data.
> Input data in is complete, Click Button "Enter data into the sheet
> Format",
>
> See Attachment.
>
> 2013/5/27 David Grugeon >
>
>> Bulloo Shire Counc
Thanks David for your quick help..
On Monday, May 27, 2013 5:40:01 AM UTC-5, David Grugeon wrote:
>
> Bulloo Shire Council in Thargomindah Queensland Australia.
>
> Regards
> David Grugeon
>
>
>
> On 27 May 2013 16:13, VBA VABZ > wrote:
>
>> hey
>>
>> for which co you work.
>>
>> thx
>>
>>
>>
is it resolved?
On Mon, May 27, 2013 at 7:58 PM, Bé Trần Văn wrote:
> Cell D3:D9 and :D24 to enter data.
> Input data in is complete, Click Button "Enter data into the sheet
> Format",
>
> See Attachment.
>
> 2013/5/27 David Grugeon
>
>> Bulloo Shire Council in Thargomindah Queensland Australia
Cell D3:D9 and :D24 to enter data.
Input data in is complete, Click Button "Enter data into the sheet Format",
See Attachment.
2013/5/27 David Grugeon
> Bulloo Shire Council in Thargomindah Queensland Australia.
>
> Regards
> David Grugeon
>
>
>
> On 27 May 2013 16:13, VBA VABZ wrote:
>
>> he
Bulloo Shire Council in Thargomindah Queensland Australia.
Regards
David Grugeon
On 27 May 2013 16:13, VBA VABZ wrote:
> hey
>
> for which co you work.
>
> thx
>
>
> On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
>
>> Hello,
>>
>> ** **
>>
>> Please find attached the sheet.
>>
>>
hey
for which co you work.
thx
On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
> Hello,
>
> ** **
>
> Please find attached the sheet.
>
> ** **
>
> Macro Requirement : I will receive the data for 20 associates in my team
> in a separate sheets (20 Sheets) in the attached format. Now
Which bit of this are you not able to do yourself? Have you tried
recording the steps, examining and understanding the code produced, and
then stringing it together to make a complete routine to do what you want?
I operate on the "teach a man to fish" principle. If you want me to
produce the ent
why using macro?... just select hole column and change format
Regards,
Team XLS
On Mon, Mar 4, 2013 at 11:21 AM, Prashant Pawle wrote:
> Dear Team,
>
> Please amend macro in attached sheet to automatically select range based
> on cell value.
>
> Thx in advance
>
> Regards,
>
> Prashant
>
> -
Will you please elaborate ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 17 October 2012 11:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro Help: Repeat the
all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Sundarvelan N
To: excel-macros@googlegroups.com
Sent: Wed, October 17, 2012 8:13:09 AM
Subject: Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move
Please find
Please find the attached file for your reference
Opne the file enable the macro and press ctrl+m
and click any where in the excel you will find my requirement.
I need this task should be completed by mouse/keyboard move.
Thanks
N.Sundarvelan
9600160150
On Wed, Oct 17, 2012 at 5:26 PM, Paul Sc
You explanation is somewhat vague..
By breaking it down into individual definitions:
"Repeating the macro" implies that you have a macro in mind.. good start.
"cursor" is a general term referred to the "type-in bar", usually a vertical
bar
(|) or underscore (_).
"cursor move" would then be mov
Hi ashish,
Is there any way to keep common code for all sheet?
Because i may have to use this code on various sheet on many time.
On Sat, Apr 16, 2011 at 11:35 AM, ashish koul wrote:
> change
>
> Sheets(1)
>
> as per your requirement
>
> activesheet or Sheets(" name of sheet")
>
>
>
> On Fri
change
Sheets(1)
as per your requirement
activesheet or Sheets(" name of sheet")
On Fri, Apr 15, 2011 at 11:57 PM, Prabhu wrote:
> Hi Ashish,
>
> Thanks, But when i run the macro i had an issue
>
> 1) It is woking only on the Sheet 1 only not other sheet
>
> 2) I want to use this code with
Hi Ashish,
Thanks, But when i run the macro i had an issue
1) It is woking only on the Sheet 1 only not other sheet
2) I want to use this code with other macro as a Continuation Plz help from
which line i have to copy to my exising macro code.
Regards,
Prabhu
--
---
Hi
Try
Sub Test()
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If IsError(Cells(i, "A")) Then
Cells(i, "A").EntireRow.Delete
End If
Next i
End Sub
On Fri, Apr 15, 2011 at 3:24 PM, Prabhu wrote:
> Hi,
>
> I want to delete particular rows only in my work sheet which cont
Why "at one time"?
I don't think you're going to get that...
But if you use:
Option Explicit
Sub Del_Rows()
Dim rCnt, R
Sheets("Data").Select
Range("A1").Select
Application.ScreenUpdating = False
rCnt = ActiveCell.SpecialCells(xlLastCell).Row
For R = rCnt To 1 Step -1
try this code
assuming you have data in col a to col c and you want to delete all records
with #n/a in col C
Sub TEST()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
If Sheets(1).FilterMode Then
Sheets(1).ShowAllData
End If
Sheets(1).Range("A1:C" & R
Thanks Ashish
Hugs & Love
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, February 24, 2011 5:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro Help - Please!
hi
+ sign was earlier
Thanks a ton Rohan!
Long Live, Excel-Macro group.
Cheers
Kamal
On Wed, Feb 23, 2011 at 5:15 AM, Rohan Young wrote:
> HI Kamal,
>
> Please see the attachment if it helps,
>
>
> Regards
>
> ROHAN
>
>
> On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Kamal,
>>
>> Please see a
Hello,
Some people have this habit ; it’s useless.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jenie
Envoyé : mercredi 23 février 2011 20:38
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Macro Help - Please!
Hello excel
el-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rohan Young
> *Sent:* Wednesday, February 23, 2011 8:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro Help - Please!
>
>
>
> HI Kamal,
>
>
>
> Please
"Complete",""))
Thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohan Young
Sent: Wednesday, February 23, 2011 8:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro Help - Please!
HI Kamal,
I think, it could be with IF Formula
For Example
'(=IF(D7="step","complete",IF(D7="vp","pass",""))'
if value in D7 Cell.
On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
> Hello Excel Gurus,
>
> Need small favour from experts,
> I have two columns in Excel, I need a macro, where if Column A
HI Kamal,
Please see the attachment if it helps,
Regards
ROHAN
On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI wrote:
> Dear Kamal,
>
> Please see attached sheet..if it help..
>
> On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
>
>> Hello Excel Gurus,
>>
>> Need small favour from experts
Dear Kamal,
Please see attached sheet..if it help..
On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
> Hello Excel Gurus,
>
> Need small favour from experts,
> I have two columns in Excel, I need a macro, where if Column A contains
> value as "Step", column B should populate "Complete".
> If
HI Kamal,
Here is the sample workbook.
Regards,
Mrinal Saha
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN grou
Thanks
Its difficult to understand for me
Thanks Once again - my purpose is solved
Dharmesh Shah
On Fri, Oct 15, 2010 at 11:44 AM, Vishal Angre wrote:
> *code is Thisworkbook in VBAproject *
>
>
> On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah
> wrote:
>
>> Thanks Vishal
>>
>> Its working
>>
*code is Thisworkbook in VBAproject *
On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah wrote:
> Thanks Vishal
>
> Its working
>
> Can u explain how u done this (If its posible)
>
> Once Again Thanks
>
> Dharmesh Shah
>
>
>
>
>
> On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
>
>> NOW OPEN FI
Thanks Vishal
Its working
Can u explain how u done this (If its posible)
Once Again Thanks
Dharmesh Shah
On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
> NOW OPEN FILE AND U WILL SEE ADDIN MANU AND DHARMESH SUB MANU
>
>
> On Tue, Oct 12, 2010 at 12:39 PM, Dharmesh Shah
> wrote:
>
>
Hi
The best and the easiest way.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 12:12 am, Umesh Dev wrote:
> Hi Sundervelan,
>
> I have enclosed a file which will automatically update the moment you make a
> change in the Master sheet.
>
> Regards
> Umesh
>
>
>
> On Wed, Aug 18, 2010 at 12:06
Dear Maulik,
There are some materials uploaded in "Files" section of this group itself.
http://groups.google.com/group/excel-macros/files
You can also search google for other learning materials.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gma
36 matches
Mail list logo
