Thread: Range in a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alvin Kuiper alvin Kuiper is offline
external usenet poster
 
Posts: 175
Default Range in a row

Hi
here is what i use in a combobox

Dim rng As Range
Set rng = Range(Range("a1"), Range("a1").End(xlDown))
Me.navne.List = rng.Value

This working
How can i use this to take the range in row 1 not down.

Alvin