VB coding

  • Thread starter Thread starter Fern
  • Start date Start date
F

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!!
 
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!!
 
Back
Top