Some trouble assigning a string to a variable

[Howard]

Hi Howard,



Am Sat, 7 Dec 2013 14:47:28 -0800 (PST) schrieb Howard:






I tested the workbook and everything is fine.

In all your posts you wrote that you wanted the data from sheet "Data"

column E in sheet "Studies" column F in the first empty row.

With all checkboxes I tried the data is written in F42 downwards.

Do you looking for the data in column H (H5 downwards) because one of

the variables is called hFill?

Then you only have to change the "F" to a "H" in

Sheets("Studies").Cells(Rows.Count, "F").End(xlUp).Offset(1, 0) _

.Resize(rowsize:=UBound(varOut)) = varOut



If that is not the solution then look how c, LCell and varOut change

when you step through the code with F8



I go to bed now. Until tomorrow.





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Good morning Claus.

Then you only have to change the "F" to a "H" in

That fixed it!! Works very nice now.

And very clever how you count the blank rows between the entries and that in essence is the resize row number.
(I did find the very last entry in the column needs a 'boundary' to use for its blank row count. I used ****** ******.)

I can't thank you enough for your patience and the excellent solution.

Regards,
Howard

 

[Howard]

Good morning Claus.






That fixed it!! Works very nice now.



And very clever how you count the blank rows between the entries and that in essence is the resize row number.

(I did find the very last entry in the column needs a 'boundary' to use for its blank row count. I used ****** ******.)



I can't thank you enough for your patience and the excellent solution.



Regards,

Howard

Hi Claus,

I got this from the OP I was helping.
I and asked for help here on a code hang up I had.

*******

Hi Howard - THANK YOU!
I spent all day going over this and testing as you suggested. It works beautifully! Thank you for going above and beyond.

(Here a couple lines about suggestions I made)

5. I have learned my lesson! No more merges.

Thank you again, Howard!!! I cannot thank you enough.
This is phenomenal. I'm adding in the actual data today and looking forward to it.

******

You are boldly credited in the code top and bottom, for the magical portion you supplied to really make it work.

Regards,
Howard

 

[Claus Busch]

Hi Howard,

Am Mon, 9 Dec 2013 15:49:09 -0800 (PST) schrieb Howard:

I got this from the OP I was helping.
I and asked for help here on a code hang up I had.

great ;-)
I am always glad when a client likes the solution and he is contented.


Regards
Claus B.