Range with variables

[Imh0tep]

Hi all,

I have variable alfa, which contains number of last non-empty cell from column A from Sheet2. Following code works fine.

[COLOR=#000000][FONT=monospace]Worksheets("Sheet1").Range([/FONT][/COLOR][COLOR=#0000cd][FONT=monospace]"B30:B" & alfa + 28[/FONT][/COLOR][COLOR=#000000][FONT=monospace]).Value = Worksheets("Sheet2").Range("A2:A" & alfa).Value[/FONT][/COLOR]

I would like to have next variable (called beta) also in first argument. I tried to do it analogical but without succes.

I tried "B" & beta +1 : "B" & alfa +28 and "B" & beta+1 & ":" & "B" & alfa + 28 instead of "B30:B" & alfa + 28 but it doesn't work too.


Variable beta contains number of row which contains some special symbol (^).


Do you have any idea how to solve it?

Thank you very much

 

[Fluff]

Try

   Sheets("sheet1").Range("B" & Beta + 1 & ":B" & Alpha + Beta - 1).Value = Sheets("Sheet2").Range("A2:A" & Alpha).Value