Multiple Problems with a loop

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Multiple Problems with a loop

FAQ

Thread Tools

Display Modes

06-09-2017, 09:38 AM

Radtastic10 Radtastic10 is offline

Windows 7 64bit Multiple Problems with a loop

Office 2010 64bit

Novice

Join Date: Jun 2017

Posts: 5

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro Loop Help	Twizzle008	Word VBA	15	09-18-2015 03:20 PM
Loop - Row increment	jrt	Excel Programming	1	04-16-2015 01:46 PM
Having Problems with Multiple Keys	sorengg	Mail Merge	5	03-14-2013 10:06 PM
How to a For loop in VBA	Jennifer Murphy	Word VBA	1	01-29-2013 03:30 AM
While loop not working right	Cbrehm	Excel Programming	0	05-11-2011 11:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 PM.