Want to expand range by one column to left and right

[connorwb93]

Hi,

I wrote a macro that creates a range of every entry in a list of statement items that matches a certain keyword. The list is formatted with date in the A column, then item description (what is selected in the range variable), then transaction amount.
The ultimate goal is to sort everything that matches the keyword into a different column, so it seems like one easy way to do this is to expand the selection of each description to include the cells to the left and right of it, then move that new range.
Can somebody instruct me in how I would expand it like that? Or if there is a much better way to accomplish this, feel free to try to explain it. I'm relatively new to VBA and programming so I apologize for my ignorance.

Thanks

[jindon]

so it seems like one easy way to do this is to expand the selection of each description to include the cells to the left and right of it, then move that new range.

Perhaps

Please Login or Register  to view this content.