Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
'Populate column B, copies value in B2 of sheet declared down B 'For as many rows that are in columnG, then copy/paste special values Range("B2").Select With Sheets("Kentwood Order Entry Sheet") 'the sheet tab name in SALESORDERDOWNLOAD.XML .Range("B3:B" & .Cells(.Rows.Count, "G").End(xlUp).Row).Formula = "=(B2)" End With Range(Selection, Selection.End(xlDown)).Select Application.CutCopyMode = False Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|VBA kill active workbook in before close event with condition||3||39|
|Excel formula to calculate ID #||4||41|
|can excel files with data model work in excel 2010?||3||40|
Join the community of 500,000 technology professionals and ask your questions.