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: 4
Default my first macro - super simple for any veteran... help appreciated!

Since I dont have ANY experience programming (yet), I am limited to
creating macros by only recording them.

So, I recorded my first Macro, everything works great! But it only
works perfectly on the sheet I created it with and not on any other of
the same type, as intended. The issue is simple, the recorded macro
inserted a fixed range as shown he

Range("G2").Select
Selection.AutoFill Destination:=Range("G2:G289")
Range("G2:G289").Select

I simply must be able to replace the specified 'G289' in this case
with a variable associated to the row count in the Column G. I have
tried Help File, Googling for a while and just plain trying to learn
VBA programming on my own... but I have lost patience and am hoping
for a veteran to just tell me how to do it so I can get it done
finally!

Thanks in advance,
mtupper
VBA Rookie (future VBA junkie)
 
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
Super & Subscript raj74 Excel Discussion (Misc queries) 4 September 11th 08 02:18 PM
Super 2-axis chart Autoscale Macro ;-) Patachoup Excel Programming 5 June 4th 07 10:41 PM
super impose dynagirl Excel Discussion (Misc queries) 5 April 11th 06 08:54 AM
THE SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE Links and Linking in Excel 0 December 22nd 05 10:51 PM
Super/SubScript Button Macro Dave Peterson[_5_] Excel Programming 0 January 12th 05 02:45 AM


All times are GMT +1. The time now is 11:56 AM.

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"