Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a range of rows based on a variable; syntax error
I have a very basic question about how to express a certain range of rows
that I wish to delete in a macro. It's not tricky (I don't think), I just haven't been able to find the right help file or webpage to explain the phenomenon to me (I'm very new at this). Basically I want to delete a number of rows based on a variable (integer). If the variable is 1, for example, I want to delete rows 13-26. It is possible for me to do this with the following line: Worksheets("Math").Rows("13:26").Delete The problem is, I can't figure out how I should do this when I want to bring my variable into it. For example, I would love to be able to use: Worksheets("Math").Rows(MyVariable * 13:MyVariable*13 + 13").Delete But that's not the right syntax at all. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a range of rows based on a variable; syntax error
Hi,
myvariable = 1 Worksheets("Math").Rows(myvariable * 13 & ":" & myvariable * 13 + 13).Delete Mike "Babymech" wrote: I have a very basic question about how to express a certain range of rows that I wish to delete in a macro. It's not tricky (I don't think), I just haven't been able to find the right help file or webpage to explain the phenomenon to me (I'm very new at this). Basically I want to delete a number of rows based on a variable (integer). If the variable is 1, for example, I want to delete rows 13-26. It is possible for me to do this with the following line: Worksheets("Math").Rows("13:26").Delete The problem is, I can't figure out how I should do this when I want to bring my variable into it. For example, I would love to be able to use: Worksheets("Math").Rows(MyVariable * 13:MyVariable*13 + 13").Delete But that's not the right syntax at all. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a range of rows based on a variable; syntax error
Thanks - I could have sworn I had tried that, but I must have gotten some
part of it wrong. Your suggestion solved it perfectly, thanks. "Mike H" wrote: Hi, myvariable = 1 Worksheets("Math").Rows(myvariable * 13 & ":" & myvariable * 13 + 13).Delete Mike "Babymech" wrote: I have a very basic question about how to express a certain range of rows that I wish to delete in a macro. It's not tricky (I don't think), I just haven't been able to find the right help file or webpage to explain the phenomenon to me (I'm very new at this). Basically I want to delete a number of rows based on a variable (integer). If the variable is 1, for example, I want to delete rows 13-26. It is possible for me to do this with the following line: Worksheets("Math").Rows("13:26").Delete The problem is, I can't figure out how I should do this when I want to bring my variable into it. For example, I would love to be able to use: Worksheets("Math").Rows(MyVariable * 13:MyVariable*13 + 13").Delete But that's not the right syntax at all. Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a range of rows based on a variable; syntax error
Another one:
Worksheets("Math").Rows(MyVariable * 13).resize(14).Delete Babymech wrote: I have a very basic question about how to express a certain range of rows that I wish to delete in a macro. It's not tricky (I don't think), I just haven't been able to find the right help file or webpage to explain the phenomenon to me (I'm very new at this). Basically I want to delete a number of rows based on a variable (integer). If the variable is 1, for example, I want to delete rows 13-26. It is possible for me to do this with the following line: Worksheets("Math").Rows("13:26").Delete The problem is, I can't figure out how I should do this when I want to bring my variable into it. For example, I would love to be able to use: Worksheets("Math").Rows(MyVariable * 13:MyVariable*13 + 13").Delete But that's not the right syntax at all. Any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
Deleting Rows based on Column Critieria | Excel Discussion (Misc queries) | |||
Deleting rows based on number of characters | Excel Discussion (Misc queries) | |||
Deleting rows based on IF statement | Excel Discussion (Misc queries) | |||
Deleting rows based on a cell value | Excel Worksheet Functions |