sheetsmaster

Dim lastRow As Long destrow = Sheets("Master Wheel").Range("A" & Rows.Count).End(xlUp).Row Columns("T:T").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("T2").Select ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(VLOOKUP(RC[-19],'Master...

Hi, I'm trying to consolidate info held on 128 sheets using the code below but it doesn't work. Can anyone suggest a correction? Sub CombineSheets() Dim rng As Range Set rng = Sheets("master log").Range("A2:s25000") Sheets("master log").Activate rng.ClearContents Dim i As Integer For i = 1 To...

Hello, I have a worksheet with three columns; column A is for the date, column B is for the student initials, and column C is where the instructor will enter his comments based on the training that day. My question is regarding the comments added in column C. Just to give a brief layout of...

hi all, someone know any problem might happened in my below code? i record my code to add a new sheet and then refer to my main code on current sheet, but it's doesn't work property thanks for the advice :) Sub Macro001() ' ' Macro001 Macro ' ' Sheets("MASTER").Visible = True...

This code was working file, I moved a search box from one worksheet to another and now when I hit the search button it brings up the opportunity to save the file. If I hit cancel it completes the code and does the right thing. The code in bold is what was changed. Any ideas are appreciated...