Results 1 to 2 of 2

How to make the code to print 250 cells t o another sheet more shorter

Threaded View

  1. #1
    nader
    Guest

    How to make the code to print 250 cells t o another sheet more shorter

    in the sheet1:
    I have a tablet compose form 250 cells and 8 (a,b,c,d,e,f,g,h,i) columns
    in the sheet2 :
    I have 4 tablets, each tablet compose form 4 cells and 2 columns

    I want to print the cells in sheet1 in the 1st row to the 1st tablet in sheet2
    the cells in sheet1 in the 2nd row to the 2nd tablet in sheet2
    the cells in sheet1 in the 3rd row to the3rd tablet in sheet2
    the cells in sheet1 in the 4th row to the 4th tablet in sheet2

    this will required from me a big code if I use like this code for each 8 columns
    to the four tablets, and I have a 250 clles

    Sheets(2).Range("a8").Value = Sheets(1).Range("a8").Value
    Sheets(2).Range("a9").Value = Sheets(1).Range("a9").Value
    Sheets(2).Range("a10").Value = Sheets(1).Range("a10").Value
    Sheets(2).Range("a11").Value = Sheets(1).Range("a11").Value
    so how to make this code shorter.

    I hope I'm a clear, and thank you for help
    Last edited by nader; 10-14-2007 at 01:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1