Try:
Dim numCompounds As Long
Dim cnt As Long
Dim CmpdRng() As Range
Dim count As Long

numCompounds = InputBox("Enter the Number of Compounds")

ReDim CmpdRng(numCompounds)
For count = 1 To numCompounds
Set CmpdRng(count) = Application.InputBox(prompt:="Please Select Data
for Compound ", Type:=8)
Next


" wrote:

Is it possible to have a user select multiple cells associated with a
sample? My vba is below, but it keeps giving me an error on having the
InputBox = type 8 (range). Is this not possible? I figured it would
be fine to have the layout like this...but if someone knows of a better
way that would work it would be fine.

Sub Cmpds()

Dim Compounds() As String
Dim numCompounds As Long
Dim cnt As Long
numCompounds = InputBox("Enter the Number of Compounds")
ReDim Compounds(1 To numCompounds)
For cnt = 1 To numCompounds
Compounds(cnt) = InputBox("Please Enter Compound " & cnt)
Next

Dim CmpdRng() As String
Dim count As Long
ReDim CmpdRng(1 To numCompounds)
For count = 1 To numCompounds
CmpdRng(cnt) = InputBox("Please Select Data for Compound " &
count, Type:=8)
Next

End Sub