shifting columns

**clc3** · 07-22-2012, 09:45 PM

This is an example of the code I am using to populate textboxes a user form.

Please Login or Register  to view this content.

now I need to shift over columns instead of down rows... I had hoped that it would be as simple as this:

Please Login or Register  to view this content.

but it is not. I know this has to be a simple fix but I just do not know it, any help would be greatly appreciated.

**protonLeah** · 07-22-2012, 10:02 PM

Instead of .range(("a" + i) &"2").value,
try .Cells(rownum, calculated column number).Value (e.g. Cells(2,a+j).Value)

**clc3** · 07-22-2012, 10:13 PM

Thanks! That will works, however I just tried using the offset function

Please Login or Register  to view this content.

which seems to be working pretty well.

**Cutter** · 07-23-2012, 12:00 PM

@ clc3

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.