select all data in column

Hi All, I'm trying write a MACRO to do the following (As a small porti of a large MACRO project): (Consider that I will have a varying number of COLUMNS and ROWS each time the report is generated, so, the columns needed manipulated will be different each time. This is why I need to use Header...

Hello I need help with a macro to select all the rows in the column of the active cell. The number of rows that are selected are based on the number of rows with data in column A. However I'm getting an error when I use the code below: Sub SelectColumn() Dim CC As Long myfield1 =...

I'm sure this is an easy problem and I couldn't find the answer anywhere. I have three subforms that lead into the same table (It had to be set up this way for the sake of a different query). So I would like to identify which Subform the data came from by entering a 1 2 or 3 in field "Type" of...

Hello, I use the following code to select all data in a column. In my example data available only in two cells (M8 and M9). When I used the following code it selects from M1 to M9. Sometimes I may have one or many data. Range(Selection, Selection.End(xlDown)).Select Range(Selection...