|
-
Mar 30th, 2006, 07:45 PM
#1
Thread Starter
New Member
Newbie problem for VBA/Excel user
Hello
I have been trying to create a simple macro in Excel but i am doing something wrong, obviously.
*********************************************
Sub Amount()
'
' Keyboard Shortcut: Ctrl+q
'
if (((Range("A1").Select < 15000) or ((Range"A1").Select > 400000)
Print "Too small or too large number"
End If
End Sub
*********************************************
I am typing a number in cell A1. If that number is larger than 400000 or smaller than 15000 then it should print something. When i run this macro VB gives a "method not valid without suitable object". Does anyone understand what the problem is? Your help is appreciated. Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|