Some trouble assigning a string to a variable

  • Thread starter Thread starter Howard
  • Start date Start date
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
Click to expand...



Good morning Claus.
Then you only have to change the "F" to a "H" in
Click to expand...

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
 
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
Click to expand...

Hi Claus,

I got this from the OP I was helping.
I and asked for help here on a code hang up I had.
*******
Click to expand...
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.
******
Click to expand...

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

Regards,
Howard
 
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.
Click to expand...

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


Regards
Claus B.
 
Back
Top