Posted to microsoft.public.excel.programming

Miree

external usenet poster

Posts: 90

command button not working

Thank you Paul worked perfectly.

"Miree" wrote:

I have a code, which works when i select run but i can not connect it to a
command button, I can get the code to work if i paste in to the work book(but
not the command button) but can not get it to work in the worksheet where
command button is.

Sub AutoNumber()
' AutoNumber Macro
Sheets("Formulations").Select
i = Range("A2") + 1
Sheets("Formulation").Select
Range("E17:E18") = i
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Deselect Command Button by Selecting another Command Button	gmcnaugh[_2_]	Excel Programming	3	September 2nd 08 05:59 PM
Code created in a Macro not working for a Command Button	Amber_D_Laws[_8_]	Excel Programming	15	January 13th 06 10:35 PM
command button isn't working	Nydia	New Users to Excel	1	April 29th 05 10:31 PM
Command Button not working once sheet is protected	Janice[_3_]	Excel Programming	5	November 17th 03 10:22 PM
Non Working Cells after command button	rlgh60	Excel Programming	1	November 6th 03 11:01 PM

All times are GMT +1. The time now is 08:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us