VB coding

[Fern]

I want to copy the information(text) on
Spreadsheet: 'Breads and loafs'
Cell: H5

copy that cell

on to Spreadsheet: 'Basket'
and find the next blank between C6 - C16


Helpppp!!

 

[michdenis]

hi,

Try this.

Worksheets("Breads and loafs").Range("h5").Copy _
Worksheets("Basket").Range("C17").End(xlUp)(2)




"Fern" <[email protected]> a écrit dans le message de groupe de discussion :
(e-mail address removed)...
I want to copy the information(text) on
Spreadsheet: 'Breads and loafs'
Cell: H5

copy that cell

on to Spreadsheet: 'Basket'
and find the next blank between C6 - C16


Helpppp!!