What cell is my data coming from?

Thanks Max,

I did know about there are no cells to the left of column A but this is fully occupied with the data I need to copy - the first column with an empty cell is (should be) always in column B so fortunately the issue cannot arise - and if it does then it would highlight an error in the spreadsheet setup which must then be addressed manually. There would be an error handler built in so this will not be an issue ... I say that with lots more confidence than I actually have! (but even without an error handler the macro will stop with an error)

Perhaps Im being thick here, but I dont know how to make myself clearer on this. Basically I get a value from a sheet called "Source" from cell G7. The code I have then places it into the first blank cell on a different sheet (lets call it "Target" for this example) which is the active sheet - for this examples sake, lets assume the empty cell is C3. All this so far I have achieved with the script I put earlier.

Now the bit im stuck on is ..
I need to copy the data in the cell next to where I have just pasted (in this example sheet "Target" cell B3) and paste it into cell H7 on sheet "Source".

I believe I have come up with a chunky solution, but I'm sure it can be refined. I have incorporated your line and it seems to work on my test spreadsheet. Im not sure how scailable this is though - only the Gods know at this stage.

Sub FillMeIn()
Sheets("Source").Select
x = 1

For Each cell In Range("A1:D14").SpecialCells(xlCellTypeBlanks)
cell.Value = Sheets("Source").Range("G7")

Cells(cell.Row, cell.Column - 1).Select

        Selection.Copy
        Sheets("Target").Select
        Range("G7").Select
        ActiveSheet.Paste
        Sheets("Source").Select

If x = 1 Then Exit For

Next cell

End Sub

Thanks for your help, but if you can think of a better way then please let me know. (I do know that it is possible to manipulate sheets without making tham active and then switching back again, but its late and I need that bed that is calling me from afar.

Thanks Again,

Brian.

Superb!

Thanks Max.

A combination of both of your comments and melding it into the code I already have has done the job nicely and allowed me to rid myself of several lines of code just in that bit that was holding me back. I can also see where your code can replace lots of my coding in other areas of my script, so even more of my awful code can go!

Thank you so much for your help. (but I'm still not volunteering for any more coding jobs!).

Unfortunately the project is still not complete, but the end is in sight. Hopefully no more coding questions form me ... ever!

Thanks again.

Brian.