You have not mentioned any bracket, coma etc anywhere in the code...
Like
if(sheet1.cells(3,39))="4" then
you need to write the code in correct format first.
To lock the cell you can have the following code
Cells.Select
Selection.Locked = True
Regards,
Tariq Kamal
www.gate2quality.com
On Wed, Jan 14, 2009 at 6:00 AM, Thunderwhelmed <april.hil...@gmail.com>wrote:
>
> Hi all,
>
> I have a worksheet that contains a column of 8 dropdown lists (combo-
> boxes) from a range in a different sheet. I have the (numerical)
> results of each selection set up to display in a hidden column. In
> another cell, I used the COUNTIF function to count the results of all
> selections >0 (0=no selection).
>
> What I need to do is, based on that count, use a command button to
> activate another sheet in the same workbook, select a range of cells,
> then copy + paste into yet another sheet.
>
> Basically:
>
> if Cell C39=4, then
> Activate Sheet3
> Select range A1:M7
> Copy range
> Activate Sheet2
> Paste range into Sheet2, starting at cell A7.
>
> --OR--
>
> if Cell C39=5, then
> Activate Sheet3
> Select range A9:N15
> Copy range
> Activate Sheet2
> Paste range into Sheet2, starting at cell A7.
>
> etc, etc, when C39 = 6, 7, or 8
>
> I know it's all pretty much there, but I don't know the VB language.
>
> I would really appreciate some help! Thank you in advance!
>
> April
>
> PS, does anyone know how to lock the contents of an entire sheet once
> that command button has been pressed? thanks!
>
> >
>
--
http://www.gate2quality.com
http://www.rideahead.blogspot.com
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~----------~----~----~----~------~----~------~--~---
