Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Easy VBA "Range" question

Comment:

Easy enough, I'm trying to copy a template and let the user define where they was the template copied. The problem is in the Range statement. All of the help files say that the range has to be a cell reference, but the InputBox command says that you CAN ask for a range by adding the "type:=8" at the end of the InputBox statement. Any ideas? Sub COPY_TEMPLATE() ' ' COPY_TEMPLATE Macro ' ' Range("A3:J33").Select Selection.Copy Set myRange = Application.InputBox(prompt:="What CELL do you want to put it in?", Type:=8) Range("myRange").Select ActiveSheet.Paste End Sub

Name: Razor2.3
Date: March 9, 2008 at 06:33:50 Pacific

Reply:

It returns a Range object. It'd be as if you typed: Set myRange = Range(InputBox("What CELL do you want to put it in?")) But with the added option of the user actually clicking on the cell he wants.

0

script that searches line...

Question about Jexepack o...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am doing some error handling in my code and am trying to write an IF statement where if a certain condition is met the program will end. i.e. If x = 0 Then End Program. Something like that. Any ...

Summary: I think some context is lost... have you tried "for /?" If you still cant understand, i will try to explain... c:\>for /? Runs a specified command for each file in a set of files. FOR %variable IN (s...

Summary: I am trying to write code (newbie here) to allow me to process the 1st 500 rows of an excel spreadsheet and replace certain cell values using a dynamic raning scheme: Dim intCredit As Integer Dim s...