Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Product Inquiry: SpreadsheetWEB | Excel Discussion (Misc queries) | |||
Chart Inquiry | Excel Discussion (Misc queries) | |||
Lookup inquiry again | Excel Discussion (Misc queries) | |||
Formula Question - 2nd Inquiry | Excel Discussion (Misc queries) | |||
Pivot Table inquiry | Excel Discussion (Misc queries) |