HI, I'm really glad to see this forum. cool!
I am working on trying to getmyu macro to run.
I'm using Office for MAC on panther.

Situation: I highlight manually a certain bunch of cells.
A) I want to hit a macro key to then copy that range of cells and
B) go into another workfile and
C) past that range of cells into the first empty cell it finds under
all the other filled cells, in a certain column.

So far I can get it to do A and B. In my attempts to get it to do C I
tried clicking on the first empty cell (hoping that magically it coul
read my mind I guess to interpret it to mean to look for the first
empty cell) and that works. BUT it only works for that cell. SO that
whenever I am in teh first workbook and want to copy another different
range of cells to teh second workbook, the macro as I currently have it
set up, will copy the range and move it to that same cell whether it is
full or not, in the second workbook. It (I?) don't know how to make it
look for the next nearest empty cell in the column going down and
paste it there instead of ontop of the same one all the time..

Here's the code I have so far:

Sub movetobizsheet()
End Sub
Sub copytobiz()
'
' copytobiz Macro
' Macro recorded 1/27/2004 by Barb
'
' Keyboard Shortcut: Option+Cmd+g
'
Selection.Copy
Windows("biz2004.xls").Activate
Sheets("DOME").Select
Range("I21").Select
ActiveSheet.Paste
End Sub

I tried typing in "EmptyCell" for the Range but that didnt' work and I
got an error. Right now it only pastes into cell I21. but I want ti to
look for the nearest empty cell and paste it there.

Thansk
regards
BArb


---
Message posted from http://www.ExcelForum.com/