Applying Macros to Selections only.

Eli,

So are you trying to figure out how to remove a column, but only the rows in the currently selected area? Do you select the entire range that the macro modifies before starting your macro?

If it is based on an area you manually highlight before processing, then this might be what you are looking for? If the range is pre-defined, just replace "Set rng = Selection" with "Rng = the range you want"

Sub delete_column_in_row_range()
Dim rng As Range
Dim frow, lrow As Integer 'first and last rows of your selected range
Set rng = Selection ' this takes selected area to figure out the rows
frow = rng.Cells(1, 1).Row 'first row in selected range
lrow = rng.Cells.Rows.Count + frow - 1 'last row in selected range (row# on the sheet)
Range("A" & frow, "A" & lrow).Select 'selects column A within your original selection
Selection.Delete shift:=xlToLeft 'removes the selected cells and shifts the rest to the left
End Sub