PC Review


Reply
Thread Tools Rate Thread

Re: Help with a Macro

 
 
Gord Dibben
Guest
Posts: n/a
 
      10th May 2012
Sub enter_one()
With ActiveCell
.Value = 1
.Offset(1,0).Select
End With
End Sub

But wouldn't it be just as easy to type 1 then ENTER?

There must be more to this than what you describe.


Gord

On Thu, 10 May 2012 09:30:27 +0000, Helpmacro
<(E-Mail Removed)> wrote:

>
>Hi,
>
>Currently looking for a simple macro that will type the number 1 and
>shift down a cell and continue to do so each time the macro is pressed,
>hoping this is possible sorry if it is not, relatively new to Excel and
>macros.
>
>Thanks in advance.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro will not run with file.xls!macro.macro BillRobPV Microsoft Excel Discussion 2 12th Sep 2008 05:08 PM
Macro within a macro and Macro Prompts =?Utf-8?B?Y29tcGFyaW5pMzAwMA==?= Microsoft Excel Misc 3 7th Jun 2006 01:28 PM
HELP NEEDED FAST!!! HELP HELP HELP HELP HELP HELP FAST HELP NEEDED Jonathan Windows XP General 10 13th Jan 2005 03:22 AM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! -$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM
Start Macro / Stop Macro / Restart Macro Pete Microsoft Excel Programming 2 21st Nov 2003 06:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:54 PM.