Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default different ways to copy a range?


botha822 wrote:
Whats wrong with this syntax?
WsName is a string variable that is assigned the name of a worksheet
exists.
n and i are both integer variables that are based off of For
statements.

Worksheets(WsName).Range(Cells(5, n), Cells(2415, n)).Copy _
Destination:=Worksheets("Summary").Cells(4, i)


Where is your code bugging? Are you sure your variables are being
assigned? i think you should post all of your code

AR

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The error of my ways. Cerberus Excel Discussion (Misc queries) 5 February 19th 08 09:36 PM
256 ways to make hamburger Nonni Excel Worksheet Functions 2 October 20th 06 11:50 PM
Alternative Ways to Spellcheck a Range Jay[_21_] Excel Programming 4 May 17th 06 09:43 PM
Ways of Summarising data BM Excel Discussion (Misc queries) 1 February 2nd 06 09:07 AM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"