Microsoft Office Forums - View Single Post - Multiple Problems with a loop

Thread: Multiple Problems with a loop

View Single Post

Old

06-09-2017, 09:38 AM

Radtastic10 Radtastic10 is offline

Radtastic10 is offline

Radtastic10 uses Windows 7 64bit

Windows 7 64bit Radtastic10 uses Office 2010 64bit

Radtastic10 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jun 2017

Posts: 5

Radtastic10 is on a distinguished road

Default

Figured out the problem. On the

Code:

tempstr = ActiveSheet.Cells(last_col, First_row).Value

The last_col and First_row needed to be flipped and have First_row, last col. I it was looking in row 1 column whatever instead of column 1 row whatever.

Reply With Quote