Search results for query: *

Thanks guys for taking a look, I just started reading my chapter on arrays in VBA for dummies, so I'll be figuring it out soon. Just wanted to get a little visual help, as I learn better from seeing the code and watching it work. Thanks anyways.

Hello again experts. Although I always appreciate the expert advice and help I'm given here, I do want to become somewhat independent and resourceful! I want to start adding arrays to my macros, and have never really understood the procedure. I am trying to learn on my own, through books and...

I'll give that a try as well, thank you. However when the picture is pasted into the excel sheet, it is not always the same size, and the column widths are dynamic as well. Skip Vought's solution seems to be working well.

also does code: range.width work, or does it take into account the hidden columns?

Thanks again. It actually happened to shrink my picture. I guess I was under the impression that if I was able to calculate the width of the visibe cells, and set the width of the picture to it,it would fill up the whole page. What have I assumed wrong here? is the picture being measured in a...

Thank you, that does seem to give me a value. now one more quick question, how can I put it into code: ActiveSheet.Shapes("Picture 1").Select Selection.ShapeRange.ScaleWidth (totwid / ?), msoFalse, msoScaleFromTopLeft Selection.ShapeRange.ScaleHeight (totwid / ?), msoFalse...

Hello All, Thank you for your help on past posts, your information was very helpful so I thought I would try again with a new challenge. I am trying to resize a picture on a worksheet to fit a dynamic measurement(the size of the page is different depending on the contents in cells). I am doing...

Thank you everybody for helping. After scouring through multiple forums, i beleive the answer is using arrays. So with that being said, can anyone show me an example of how an array works in regards to the original question.(i don't have much experience with arrays, as my vba/excel history up...

I appreciate anyone looking at this post and offering help. It's kind of hard to explain what I'm actually looking for but here it goes. I have a spreadsheet that contains multiple named records, see below example, HARPER HARPER MCKINLEY HARPER HARPER HARPER HARPER HARPER HARPER HARPER HARPER...