last column equivalent to my last row statement

**welchs101** · 11-07-2011, 02:43 PM

I found this last row statement below which works well. But i want to find a "last column" equivalent using this type of method..........does anyone know?

last_row1 = fl_output_sht.Columns(1).Find("*", fl_output_sht.Cells(1, 1), xlValues, xlPart, xlByColumns, xlPrevious, False, False).Row

where fl_output_sht is a user defined data type of "worksheet"

**Steffen Thomsen** · 11-07-2011, 02:51 PM

Hi,

    
   last_col1 = fl_output_sht.Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column

**welchs101** · 11-08-2011, 08:15 AM

thanks. i tried out your suggestion and it worked as well.

I also found this online and it seems to work as well.

last_col = fl_output_sht.Rows(1).Find("*", fl_output_sht.Cells(1, 1), xlValues, xlPart, xlColumns, xlPrevious, False, False).Column

last column equivalent to my last row statement

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

last column equivalent to my last row statement

Re: last column equivalent to my last row statement

Re: last column equivalent to my last row statement

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions