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

VBA Cell reference

Comment:

Hey i have a whole data sheet worth of car types ex. Sedan coupe compact etc.... i have mad a dropbox and have input all of those names, but now i want to be able to reference all the cells that say sedan if i click sedan in the dropbox... any idea how i could do this??

Bat file to check for fil...

Vb 6.0

Post Locked

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

Summary: I'm trying to reference a alue that is stored in a cell. Cell "S1" has the value "J2" stored in it. in VBA I'm using this code: cell = Sheets("Form").Range("S1") Sheets("Archive").Range(cell).Paste bu...

Summary: Hello, I have this script: '================================= Private Sub CommandButton1_Click() 'Randomizing Lists MsgBox ("Before running this script, you will need:" & Chr(13) & _ "The...

Summary: 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 cel...