[Bonmarche]

I have a spreadsheet containing a list of Invoices to print. As part of my Macro I need to be able to copy a row of data from the list (columns a to k), however the row will be different every time and is chosen by the user.

So I was looking at putting in a prompt to ask the row number to copy and go from there

Any help welcome.

[Keebellah]

welcome to the board. Dou you already have a macro that does anything special?
all you need is define a variable and an input box, then if the nr is a valid row exceute the copy command

e.a.g

Sub Sample()
    Dim xrow As Integer
    xrow = Application.InputBox("enter row nr.", "ROW", 2, , , , , 1)
    If cell(xrow, 1).Value = "" Then Exit Sub
    Range("A" & xrow & ":K" & xrow).Copy
    
    ' and here come the rest of the code to paste or whatever the macro has to do
    
End Sub

See if this helps you on the way

[Bonmarche]

Thanks sorted that out now.

The macro now picks the Invoice data I need from a list, produces an Invoice, saves the info elsewhere and updates a list of Invoices raised.

[Keebellah]

If this has answered your question, don't forget to press he Solved button on you post.