Hey all,
I have 2 headers which need to be filled in to the end of the worksheet. I have the first two rows filled out with the proper information, I just can't figure out how to move over 2 cells paste the information and continue this until the end of the file. any help is greatly appreciated!
Last edited by omgeokid; 01-31-2011 at 03:08 PM. Reason: solved
Post your code ... ideally in a sample workbook.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I figured I would get that, but I really don't know what I can and can't post due to confidentiality in my office, I'm pretty sure I can post what I have, I'd rather just not post the whole workbook/sample workbooks.
svr is dependent upon user input, and dname is handled in a loop prior to this block. I need those two headers pasted through the entire workbook in the first cell.
Please Login or Register to view this content.
You don't need to post the confidential data ... just what you want to end up with (in terms of the headings).
What does this mean: "I need those two headers pasted through the entire workbook in the first cell."?
Cells(1, 2) and Cells(1, 3) are cells B1 and C1 so how is that the "first cell".
What do you mean by "through the entire workbook"? Each sheet in the workbook? Are there any sheets that don't want this writing to them?
Regards
sorry, still new to terms and whatnot.
These two cells are headers, they are in cell b1 and c1, but I need them replicated through the *worksheet*, not workbook sorry, in the first *row* not first cell.Please Login or Register to view this content.
I'm still not sure I understand what you are trying to do but the following code will repeat those two cells across the top row.
It looks longer than it really is due to a) having to define and set up some test variables, and b) the comments which will, hopefully, clarify what's going on.
General caveat: this is one way to do it; there may be other and better ways.
Regards
Please Login or Register to view this content.
That was exactly what I was trying to do, thank you very much TM, that worked perfectly. Sorry about the confusion in describing what I needed to do.
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks