| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBox for column letter problem
On Wednesday, January 22, 2014 12:19:46 AM UTC-8, Claus Busch wrote:
Hi Howard, Am Tue, 21 Jan 2014 19:32:52 -0800 (PST) schrieb L. Howard: wks1.Range("A" & i & ":nCols" & i + nnCols).Copy wks2.Cells(1, j) change the line above to: wks1.Range("A" & i & ":" & nCols & i + nnCols).Copy wks2.Cells(1, j) Regards Claus B. Right on!! I was thinking the problem was with the InputBox not the syntax of the code line. Works great! Thanks Claus. Regards, Howard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change InputBox Range Selection to Column Letter Selection | Excel Programming | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Hybrid Mode
