Hi Leith,
Thank you so much for providing this. However I couldnt get this to work for some reason. I am not sure if I wasnt able to describe what I really wanted or not. Any way, I got the below code from a friend which lets me select the range of data on the spreadseet (This sheet is called "datapage"). I have data in rows A1:H?. If I use this code below, I can select the dynamic range of data. Now the problem I have is that I need to be able to publish this selected range of data as web page and have the web page name to be derived from sheet called "Main" and cell A25. This cell actually already have the file name (ex 122410.htm). This name changes when I open the file so I just need the file name to reference to this cell.
Hope this makes more sense and appreciate any help you can provide.
Bookmarks