Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation of cells
I have an integer variable i would like to add to a alpha
character to make a cell reference but I wasn't able to do it, can it be done. Something like: While something = something i = i+1 wend range("A1:C"&i)sort(key1 = columns("A") doesn't work but you get the idea |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation of cells
It works fine for me:
i = 20 ? range("A1:C"&i).Address $A$1:$C$20 demonstated in the Immediate window. (don't use ? in a module. the immediate window allows you to test an expression immediately - in case you are not familiar with the immediate window in the VBE). Regards, Tom Ogilvy "Gene" wrote in message ... I have an integer variable i would like to add to a alpha character to make a cell reference but I wasn't able to do it, can it be done. Something like: While something = something i = i+1 wend range("A1:C"&i)sort(key1 = columns("A") doesn't work but you get the idea |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation of cells
Try this:
While something = something i = i+1 wend range("A1:C" & i).sort key1 := columns("A") The difference is that you must put a period before the sort, you must use ":=" instead of "=" and the parenthesis are extraneous. Please let me know if that doesn't work. --- Mark Bigelow mjbigelow at hotmail dot com http://hm.imperialoiltx.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation help | Excel Worksheet Functions | |||
concatenation | New Users to Excel | |||
Concatenation | Excel Worksheet Functions | |||
Concatenation of ALPHA and NUMERIC cells? | Excel Discussion (Misc queries) | |||
Concatenation and skipping blank cells | Excel Worksheet Functions |