I have the following code the works fine but my problem is on "Date" and "Location Code", Autofill is counting up with each cell to the next date/number. How can I keep Date and Location code the same for all cells that this code autofills?
Please Login or Register to view this content.
Last edited by MichaelGG1581; 02-17-2013 at 01:35 PM. Reason: Revised Problem
You wouldn't have to use Autofill. You could place the same value in the whole range at one time e.g.;
Range("B1:B" & LR).Value = P
Also, vbOKCancel is not an argument for the input box. It is used with the MsgBox.
Consider this...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks