Lotus 123 conversion for range parameters

[yoshohno]

Hi,

I'm a nubie that just converted from lotus. I have a basic question that I haven't been able to find in the VBA
book or any of the help topics. When in Lotus 123, I can define a variable range with {?..?}. This alows me to define a range in the middle of a task.

I just can't find how to do it in Excel.

Thanks for any help,

Yosh

[yoshohno]

Here's what I'm trying to do - just simple stuff but will build on it

[CODE]Sub CopyRange()
'
' CopyRange Macro
' Simple copy of a range
'
' Keyboard Shortcut: Ctrl+Shift+C
'
    ActiveCell.Offset(-17, -2).Range("A1:A7").Select   
'{This is the code where I want to be able to define my own cells}
    Selection.Copy
    ActiveSheet.Paste
    ActiveCell.Offset(2, 3).Range("A1").Select    
'{Also here, I'd like to take it to another cell}
    ActiveSheet.Paste
    ActiveCell.Select
End Sub[/CODE] 

Thanks Again for the Help, Yosh

[yoshohno]

I don't understand why I'm not getting anyone to give it a try. Maybe I'm not able to explain what I'm trying to do, so here's another try.

What I want to do is write code for what happens when you engage the =sum function:

In the worksheet, you write the =sum, it shows =SUM(H14:H16)
under the formula it shows:

sum(number1, [number2],...) 

This allows you to define the range of cells you want to add. It lets you start and enclose whichever cells you want. If there were a way to see the code that Microsoft has written to do this, I'd be set.

Hope this helps clear it up, and thanks again,

Yosh

[yoshohno]

Hi All,

Apparently, there was a cheat sheet of Excel VBA equivalents for Lotus 123 Marco Commands back in version 5.0, 7.0, 97.
Microsoft Tech. Support App. Notes: "Visual Basic for App. Equivalents for .........."

Lotus 123 command {?} 
VBA equivalant: no direct macro equivalant. As an alternative use an input box.
ActiveCell.Value = Inputbox("enter string or value")

Lotus 123 command {ANCHOR}
VBA Equivalant: Selection.Resize(1, 1).Select 
Keystroke: F8
Application.Sendkeys "{F8}"

This was all I needed ... and more.

Thanks for looking, but nobody came to my help ;-(