I just wanted the program to start running if cell D7 was empty
So the test would be:
If Range("D7").Value = "" Then
now how do you include the other sheets in the code?
Worksheets("Sheet2").Range("D7,D9,D15,D17,D19,D21, D23,D25,D27,D29,D31,D33").Value _
= Worksheets("Sheet1").Range("A1").Value
Worksheets("Sheet3").Range("D7,D9,D15,D17,D19,D21, D23,D25,D27,D29,D31,D33").Value _
= Worksheets("Sheet1").Range("A1").Value
--
Jim Rech
Excel MVP
"nrage21 " wrote in message ...
|I forgot what the rest of the 1004 error said... something about
| "Application Function..." cant remember.
|
| I know this VBA Code is shameful... but just learning.
|
| "If Range("D7").Value < "" Then"
|
| I just wanted the program to start running if cell D7 was empty but if
| not empty then to end the program and do nothing.
|
| Thanks for your help... now how do you include the other sheets in the
| code?
|
| Larry
| VBA Amateur
|
|
| ---
| Message posted from
http://www.ExcelForum.com/
|