Outputting from VBA to multiple cells at once

So i've a worksheet that contains a template that is filled up using a few user forms via vba.

Currently im using

Please Login or Register  to view this content.

to output data thats been inputted into the userform textboxes.

Im also renaming single cells to avoid having to hardcode cell references everytime I make a change to the number of rows/cols etc.

The problem im having is that I have a lot of cells to rename, I cannot just select a large range and rename them, the cells are not all next to one and other.

Is there a way to rename multiple cells for referencing when I want to output data to the sheet, i.e. have 3 cells named " ExampleData " and in my vba code when I execute:

Please Login or Register  to view this content.

it outputs the same info inputted into textbox1, but to 3 different cells?


Sorry if this sounds confusing or doesnt make sense. Just want to be able to output to non-contiguous cells at the same time!

Thanks
Tom

So I have 4 cells, A1, D3, E7 and G6.

I want to populate them all at the same time, I populate one. I know I can do this via

Please Login or Register  to view this content.

But what I want to be able to do is do it on one line, under one named range. i.e.,

Please Login or Register  to view this content.

And from this line being execute, all 4 cells are populated.

I apologise for being unclear, im very new to vba!

Tom

Originally Posted by davesexcel

Your code should work, if it doesn't, supply a sample workbook

I understand that writing out one statement per cell will work. But I want to be able to group all 4 cells, under a single name and output 4 lots of identical data, from one line of code via the named range.

Can it be done is what Im asking? I dont really know as my knowledge is limited in vba, and im looking to do things quicker rather than slog through it all slowly!
Attached is a short sample of what I have, and need to change!

Thanks.

Try:-

Please Login or Register  to view this content.

Regards Mick

Originally Posted by davesexcel

You did not name the range in your sample, you said you had 3 cells named "ExampleData", you say the code does not work, you have supplied a sample workbook, and there are no named ranges. That would be why the code does not work.

Anyway,
Name the range and run the code.

you can also use,

Please Login or Register  to view this content.

I never said my code didn't work, I said it was not as efficient as what I wanted.
All I want to know is if you can rename multiple cells, that are not adjacent to each other, as the same name. For example can I rename the 4 in the sample I uploaded, under the same name, and then reference these in a function?