LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default MACRO Assistance Required

Hi some help would be appreciated - I use this MACRO to copy a cell
group from one sheet (called clipboard) to another sheet (pointslist)
at a position determined by the highlighted cell on the destination
sheet:

Sub CopyPlant()
Dim x As Variant, strRange As String

Set x = ActiveCell
strRange = InputBox("Plant Config?", "Range to Copy", "Plant")
Worksheets("Clipboard").Range(strRange).Copy (x)
End Sub

Various different groups of cells have been given 'names' on the
clipboard. When I execute the Macro I am asked to enter the 'name',
the macro then copies the requisite cell group to the points list.

I want to automate this further and give each group a seperate macro
which can be activated by a button. Initially I thought this would be
simple - just create a macro which runs the existing macro, types in
the requisite plant name and job done, but you dont seem to be able to
run a macro within a macro. Any ideas anyone? Best Regards, Andy
Fletcher.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula assistance required J.Scargill[_2_] Excel Worksheet Functions 3 April 6th 10 10:54 AM
Assistance required Anthony Excel Discussion (Misc queries) 1 June 2nd 06 11:14 PM
Formula assistance required!!! Don Excel Discussion (Misc queries) 4 February 22nd 05 08:34 PM
Macro assistance required please [email protected] Excel Programming 0 November 7th 03 08:30 AM
Excel Macro Program assistance required David Moen Excel Programming 3 November 5th 03 06:07 AM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"