Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a macro that I want to start with a paste command (data copied from another system) but only if the following conditions are met: 1 There is a worksheet open 2 It is empty 3 The first two columns have been formatted as text. I can do (2), and can set the columns to text before the paste - so can do (3). Can anyone help me with a test to ensure there is a worksheet open (a user might press the icon I set up when there is no workbook open) Thanks, Gef |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
Test to see if a workbook is open | Excel Discussion (Misc queries) | |||
test for workbook open | Excel Programming | |||
Test to see if a spreadsheet window is open | Excel Programming |