Cells or column
Posted by Becky on July 23, 2001 4:52 AM
Is it possible to program or do a macro that goes to a specific cell or column if i.e. cell A1, B1 etc!
Posted by Dax on July 23, 2001 5:27 AM
Yes, without too much trouble at all, e.g.
Sub GotoCell()
'Select A1 on the active sheet
Range("A1").Select
End Sub
Sub SelectAColumn()
'Select the entire column C
Columns(3).Select
End Sub
Is this what you had in mind?
Dax.
Posted by Becky on July 23, 2001 6:09 AM
Yes I think so I will try it out later. I am trying to copy and paste a column that the text inside will constantly change. If you let me have your email address or you email me I can send you my spreadsheet and show you what I want to do.
Many thanks for your help.
Becky
Posted by Dax on July 23, 2001 8:08 AM
Becky,
Here's my email address. Don't make it too tricky!
Dax.
Posted by Dax on July 23, 2001 8:09 AM
daxmonterellio@hotmail.com
