variables out of cell values

[sulley333]

Hi Everyone!

I have a list of cells...let's say H13:P13. They may or may not always be filled. The data is coming from selections in a list box. I would like to take whatever of the cells are populated and create variables out of them.

So, if H13 is populated than it would be call Caption1 and if I13 is populated it would be Caption2...any help on how I would code that?

This sounds so simple but I am having a tough time knowing where to start. It feels like if cell <> "" then caption1 = cell.

Thanks!

 

[sulley333]

Oh...and this may help...what I am really trying to do with those values is filter them in a pivot table. What is hard with that is you really have to hard code something. Right now I have the following code when I know what the variables are:

With ActiveSheet.PivotTables("PivotTable1").PivotFields("Brand")
    .PivotItems(brand_one).Visible = True
    For Each pi In .PivotItems
    Select Case UCase(pi.Name)
         Case UCase(brand_one), UCase(brand_two)
            pi.Visible = True
         Case Else
            pi.Visible = False
      End Select
    Next pi
    End With