How to do a regression of a series of variables without typing each variable name

Question

I want to run a regression with a bunch of independent variables from my dataset. There are a lot of predictors, so I do not want to write them all out. Is there a notation to span multiple columns so I don't have to type each?

My attempt was doing this (where my predictors are column 20 to 43):

modelAllHexSubscales = lm(HHdata$garisktot~HHdata[,20:43])

Obviously, this does not work because HHdata[,20:43] is a matrix of data, whereas I really need it to see the data as HHdata[,20]+HHdata[,21] etc.

Answer 1

Here's another alternative:

# if garisktot is in columns 20:43
modelAllHexSubscales <- lm(garisktot ~ ., data=HHdata[,20:43])
# if it isn't
modelData <- data.frame(HHdata["garisktot"],HHdata[,20:43])
modelAllHexSubscales <- lm(garisktot ~ ., data=modelData)