| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find last used column
I am using the following to try to identify the last used column and then
select the top cell of the first empty column after the last used: myRange = ActiveSheet.UsedRange NewColumn = (myRange.Columns(myRange.Columns.Count).Column) + 1 ActiveSheet.Cells(1, NewColumn).Select Can anyone tell me what I am doing wrong? This is not working. The portion in () in the second line I copied from the help file, but do not understand. -- Regards, Bryan Brassell Padgett Business Services 281-897-9141 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
| find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Threaded Mode
