LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default New Twist on a Previous Inquiry

On July 20th, 2005 I posted an inquiry regarding how to "Copy only Visible
Cells of a Variable Range between Worksheets" (See link)

http://www.microsoft.com/office/comm...8d3&sloc=en-us

Now I'm trying to take this concept one step further: I want to Copy only
Visible Cells of a Variable Range on a Variable Worksheet to another Workbook.

The workbooks are "Command.xls" (which contains all the code and two
worksheets; one for the user interface and a second which is our paste
target) and "Travel.xls" (which contains all the data on sheet one with a
subset of that data pasted to sheet two as described in the above link).

At the time the code executes, both workbooks are already open. I've tried
various approaches to this problem, but so far I just end up with a "Runtime
Error 91" Object or With Block not set. Any suggestions?

Damian Carrillo
 
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
Product Inquiry: SpreadsheetWEB smartin Excel Discussion (Misc queries) 2 May 18th 09 11:50 PM
Chart Inquiry confused!! Excel Discussion (Misc queries) 1 October 29th 08 02:39 PM
Lookup inquiry again Lorderon Excel Discussion (Misc queries) 2 August 26th 08 11:20 PM
Formula Question - 2nd Inquiry Shu of AZ Excel Discussion (Misc queries) 6 March 31st 08 10:19 AM
Pivot Table inquiry MLLEGRIS Excel Discussion (Misc queries) 0 August 22nd 05 04:07 PM


All times are GMT +1. The time now is 10:14 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"