Help remove the empty columns or rows

how to make a macro to remove the empty columns or rows.

example is in this excel file is when i hit the go button it will gather data from a webpage.

I also want it to automatically delete a certain row/column that is empty and also column d to be named Season and column c to Week so all the data can be together next to each other all at once while i hit the go button.

since column e,k,l,r, and s are empty cells i want it to automatically removed(delete) the column/row. except column d i want it to rename the cell to Season and column c where it labels G I want it to rename cell to Week.

can someone help me on this??

thanks so much!!

Hi,

I think you forgot to attach the workbook.

abousetta

opps i thought i did. sorry i'm new to site and i attached it but hit submit under message instead of the file uploaded lols.

Maybe add these lines to the end of Sub Process ():

Please Login or Register  to view this content.

abousetta

Hello can anyone help me with above questions?? check my book.xls file posted above.

I still experiencing two problems. Thanks!!

Hi Simon,

Sorry I didn't see you post till now (was sleeping) because of the time difference.

Could you please upload a new workbook with two specific worksheet:

1. Before the implementations you wanted.

2. After you manually made all the changes you wanted.

Then please just tell us in an enumerated list what it is you did. An alternative is to use the macro recorder and then we can help you clean up the generated code.

abousetta

okay please help.

this is what i want it to do. depending on the following link that i want to get data from in the macro code

"URL;http://sports.yahoo.com/nfl/stats/byposition?pos=QB&conference=NFL&year=season_" & MyYear & "&timeframe=Week" & MyWeek & "&sort=718&old_category=DT" _
, Destination:=Sheets("Web").Range("$A$1"))

if i change pos= to one of the following WR, RB,TE, D, CB, S, LB. there will be some columns that is empty with no data. is there a code to make it dynamic like automatically know to remove the empty columns so i don't need to spend time to remove the empty column rows?? each of the following WR, RB,TE, D, CB, S, LB when i enter in the url pos= will give me different number of columns that appears on the worksheet? thanks for anyone who helps me out.

heres the code inside the button.