Hi
Try this code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
cancel As Boolean)
Dim rng As Range
Set rng = Range(E Cells(Rows.Count, E).End(xlUp).Offset(1, 0).Row)
cancel = True
With Selection
Selection.Copy Destination:=rng
End With
End Sub
Here rng specifies destination
It wasn't Single click that Sajid asked for. It was double click. Yes, as
Vabs mentioned, there's isn't a single click event on sheet, however,
there's a double click event.
Private Sub Worksheet_Before*Double*Click(ByVal Target As Range, _
cancel As Boolean)
Dim rng As Range
Set rng = Range(E
Hi sajid you can also try this
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
ActiveSheet.Next.Range(Target.Address).Value = Target.Value
Cancel = True
End Sub
On Sat, Jun 8, 2013 at 10:34 AM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
Hi priti
This will keep on overriding existing data one on anothet on click.
We have to change taeget once data is copied in to.
Feedback appreciated.
Thanks
On 16 Jun 2013 16:56, priti verma pritiverma1...@gmail.com wrote:
Hi sajid you can also try this
Private Sub
yes, but he did not said he have data on another sheet , if it is then
sajid need to give clear instruction , how he want to copy data from sheet
1 to another.
On Sun, Jun 16, 2013 at 5:04 PM, VBA VABZ v...@vabs.in wrote:
Hi priti
This will keep on overriding existing data one on anothet on
Reason for using right clik was, once you double click cell you get in to
cell edit mode. So sheet change event stops, if you want to copy data to
destination more than once you can achieve it with right click.
Cheerz.
On 16 Jun 2013 17:28, Sam Mathai Chacko samde...@gmail.com wrote:
It wasn't
I do differ. The boolean argument in the double click event can be
manipulated from getting in to edit mode. That doesn't have to be
substituted with the right-click event.
On Sun, Jun 16, 2013 at 5:55 PM, VBA VABZ v...@vabs.in wrote:
Reason for using right clik was, once you double click cell
try this code to paste data in next cell which have existing data
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Dim rngRange As Range
Set rngRange = ActiveSheet.Next.Range(a Rows.Count).End(xlUp)
Target.Copy Destination:=rngRange.Offset(1)
Cancel = True
End
Dear Experts, I require in excel 2003 platform
Double Click To Copy Data To Another Worksheet sample temple require in excel
2003.
please give me above thing.
awaiting your reply,
Regards
Sajid Memon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in