Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know almost nothing about visual basic, and my supervisor asked me to add
some things into the code of a spreadsheet. I know what the code is supposed to do, but I honestly don't know if I'm doing it right. Can someone tell me what exactly this is doing?? Sub data() Application.ScreenUpdating = False For Each sht In ActiveWorkbook.Sheets sht.Activate ActiveSheet.unprotect Next Worksheets("Sheet").Visible = True Worksheets("Data").Visible = True Worksheets("Data").Activate Columns("A:B").Hidden = False region = Worksheets("Sheet").Range("Region").Value Cells(3, 3).Select cellcount = Range(Selection, Selection.End(xlDown)).Count umis = 0 umiu = 0 umip = 0 mcpls = 0 mcplu = 0 mcplp = 0 gvfpls = 0 gvfplu = 0 gvfplp = 0 mshs = 0 mshu = 0 mshp = 0 bdchs = 0 bdchu = 0 bdchp = 0 These letter groups represent product lines that are being pulled from one sheet and grouped together and placed in another sheet. I have to add another group, but can I just add it into the code because how will excel know what it is referencing too? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
visual basic | Excel Worksheet Functions | |||
Visual Basic and SP2 | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic Help | Excel Discussion (Misc queries) |