Hello all,
Firstly, this is a great forum for picking up great tips. I am new to
VBA programming and am having (to me) a small problem with my
spreadsheet.

I have my data set out in the format of Col A across to Col Y.
(database)? I am using a macro written by Ron De Bruin to select an ID
number that is always in Col A.

What I need to be able to do is after selecting the required ID
number, select the entire data for the selected row so it can be
copied to another location. I have tried the Selection.End(xltoright)
but all this does is select the very end data.

Would this forum be able to show me the command I need? or maybe a
combined macro that will find the ID number, select the complete data
and copy to another location?

Many thanks.

Les

try this
range(selection,selection.end(xltoright)).select

or without selecting
range(selection,selection.end(xltoright)).copy

--


Gary


"Johno" wrote in message
...
Hello all,
Firstly, this is a great forum for picking up great tips. I am new to
VBA programming and am having (to me) a small problem with my
spreadsheet.

I have my data set out in the format of Col A across to Col Y.
(database)? I am using a macro written by Ron De Bruin to select an ID
number that is always in Col A.

What I need to be able to do is after selecting the required ID
number, select the entire data for the selected row so it can be
copied to another location. I have tried the Selection.End(xltoright)
but all this does is select the very end data.

Would this forum be able to show me the command I need? or maybe a
combined macro that will find the ID number, select the complete data
and copy to another location?

Many thanks.

Les

Hi Johno,

To select the row data try:

Selection.Resize(1, 8)

To copy this to (say) cell A10 on Sheet2, try:


Selection.Resize(1, 8).Copy _
Destination:=Sheets("Sheet2").Range("A10")

If you are using Ron's code, you can be
certain that it is excellent. Post the code
you are using so that we can advise how y
our intent might be achieved.



---
Regards.
Norman


"Johno" wrote in message
...
Hello all,
Firstly, this is a great forum for picking up great tips. I am new to
VBA programming and am having (to me) a small problem with my
spreadsheet.

I have my data set out in the format of Col A across to Col Y.
(database)? I am using a macro written by Ron De Bruin to select an ID
number that is always in Col A.

What I need to be able to do is after selecting the required ID
number, select the entire data for the selected row so it can be
copied to another location. I have tried the Selection.End(xltoright)
but all this does is select the very end data.

Would this forum be able to show me the command I need? or maybe a
combined macro that will find the ID number, select the complete data
and copy to another location?

Many thanks.

Les

On Fri, 30 May 2008 09:52:43 +0930, Johno wrote:

To both Gary K. and Norman J. many thanks for both suggestions, both
do exactely what I want. I will have a play around with both.

Cheers

Les