Find the next blank cell in another worksheet

[Tig]

I am trying to copy and past data into the next blank cell in another worksheet in the same workbook. I currently have this macro which works if I want to find the next empty cell and past data in the current worksheet. If I try to use it to paste data into another worksheet it just highlights the line Cells(6, Range("A6").End(xlToRight).Column + 1).Select and says there is an error.



Sub
Range("B96:B122").Select
Selection.Copy
Cells(6, Range("A6").End(xlToRight).Column + 1).Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End Sub

[Debraj Roy]

Hi Tig..

Working fine in my case..

Just added a single line..

Please Login or Register  to view this content.

BTW.. You are still in <10 post.. you have still 6 chances to write code without CODE tag..


Please spend some time to read forum rules.. and requesting you to add [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags for the code section.. like above..

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[Tig]

Hi DEC2HEX(3563),

I'm new to this forum and do need to read the rules, and Vba.

You say you've added a line the code I posted but I can't see what it is.

Regards

Tig

[Debraj Roy]

Hi Tig,

Every Subroutine required a valid name to proceed..

Your code in #1, dont have Routine Name.. I just added a Routine Name tig()

Please re-check... and confirm..

[Tig]

Hi,

If you use this code it will copy data in a worksheet, find the next blank cell in row 6 of the same worksheet and paste the data there.

I want to paste the data into a different worksheet, but any code I've tried, to 'Select' or 'Activate' a different worksheet returns an error with the line of code

Please Login or Register  to view this content.

Regards

Tig