Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy & paste ranges again (2000 or xp)

    Let me explain my situation. I am a Civil Engineering Intern. My company has an old spreadsheet created in Lotus (I think). There are several Alt + keys which allow the insertion of a range of items. These Alt keys have been linked to Ctrl keys somehow when used in Excel (I just use it). The spreadsheet is used mainly for calculating pipe sizes for storm water management. It

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: copy & paste ranges again (2000 or xp)

    Here are the lotus "definitions" followed by the excel VB equivalents. Based on the Lotus macro, I would assume that "NewArea" is a named range which contains the formula to be copied in a relative fashion including the vlookup.

    /wgpd = Worksheet - Global - Protection - Disable
    = ActiveSheet.Unprotect ("password")
    [Note: I assumed that the password is literally "password" change as appropriate]
    /wtc = Worksheet - Title - Clear
    = ActiveWindow.FreezePanes = False

    /wir~/wir~ = Worksheet - Insert -Row - <enter> done twice.
    = Selection.EntireRow.Insert
    = Selection.EntireRow.Insert

    /cNEWAREA~~ = Copy - (range named)NEWAREA <enter><enter>
    = Range("NewArea").Copy Destination:=Selection

    /wgpe = Worksheet - Global - Protection - Enable
    = ActiveSheet.Protect ("password")

    Hope this helps,
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •