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 HELP REQUIRED PLEASE!

Hi,

CAn anyone offer any MACRO advice? Ive recorded the folling MACRO which
has got me 90% the

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 31/03/2005 by Andrew Fletcher
'

'
Application.Goto Reference:="ahu1"
Selection.Copy
Sheets("Points List").Select
Range("A9").Select
ActiveSheet.Paste
Range("A25").Select
End Sub

This macro copies a group of cells, in this case with the range name
"ahu1" from a sheet known as 'clipboard' and pastes them to a sheet
known as 'points list'.

I need to be able to select where in the points list sheet the paste
occurs by selecting the active cell, which in the above example refers
to cell A9 every time I run the MACRO.

Thanks to previous contributions, due to my lack of VBA skills I
couldnt get the examples kindly proffered to work. THe above is all I
require to achieve however.

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
Macro required please Dr Hackenbush Excel Discussion (Misc queries) 4 February 10th 10 09:29 AM
Macro Help Required Dan Wood Excel Discussion (Misc queries) 3 January 5th 10 05:49 PM
Macro required PCOR Excel Worksheet Functions 3 December 11th 05 07:36 PM
vba macro required ? Peter O'Leary Links and Linking in Excel 1 April 14th 05 11:49 PM
Macro help required! Don Niall Excel Programming 7 June 24th 04 07:12 PM


All times are GMT +1. The time now is 12:21 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"