hiii,
What I want is below code... But GetColumnletter Not Working
Please Login or Register to view this content.
hiii,
What I want is below code... But GetColumnletter Not Working
Please Login or Register to view this content.
Last edited by mangesh.mehendale; 09-14-2016 at 02:30 AM.
Don`t care, take care...
Regards,
Mangesh
GetColumnletter is custom function that you need also to copy in your workbook if you want it to work.
If it can't find it then you'll get error at this point.
Okay got it.... Please let me know the way to tackle this in above code I want to define "With Range("E5:" & celletr & Lastcol)" ...
let me know the code for celletr
here is what microsoft suggests
https://support.microsoft.com/en-gb/kb/833402Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
There is no necessity to convert the column number if you use the Cells property
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
hii Thanks for suggesting Cell Property but Somthing is wrong... it is pasting formulae till Col TL even though there is data till Col UR
Last edited by mangesh.mehendale; 09-23-2016 at 02:39 AM.
but Working correctly after below modification...
Please Login or Register to view this content.
In case useful, very compact and (reportedly) CPU efficient column letter methods:
VBA, for range rng:
Mid(rng.Address,2,InStr(2,rng.Address,"$")-2)
Not asked, but for completeness, for regular Excel for cell C2:
=char(64+column(C2))
That is tempting because it's so very compact, but Excel master Aladin Akyurek much preferred the following, and at the time clocked it as fastest of several choices, so I now only use this for regular Excel:
=SUBSTITUTE(ADDRESS(1,COLUMN(C2),4),"1","")
for cell C2 on current sheet. Substitute {D5} for {C2} to get a different cell like D5
Substitute {anysheet!D5} for {C2} to get D5 from another sheet. (I know that seems silly on the surface if you think about it )
Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.
Here allso a collection of some ways to get the Column Letter from a Column Number
http://www.excelforum.com/tips-and-t...explained.html
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks