View Single Post
  #1   Report Post  
Old July 7th 06, 04:21 PM posted to microsoft.public.excel.programming
Colin Foster[_5_] Colin Foster[_5_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2006
Posts: 4
Default Using Sheet names & Workbook names in VBA coding

Hi,
I've got a macro working (thanks to help from this NG) to delete certain
specified rows of data from a spreadsheet. Unfortunately, I have to go into
the VBA code to change th esheet name from "Sheet1" to the actual name of
the sheet. As I want to be able to use this code on more than one sheet (&
possibly across workbooks) is there a simple line of code that I can put
into the VBA to automatically put in th ecorrect sheet name & file name?

Regards
Colin Foster