I'm trying to convert the static value of "X372:BV372" in line 1 on thescreenshot into a dynamic range based on last row, but I'm getting an "AutoFill method of Range class failed" with my modifed syntax in line 2 on the screenshot..
Please Login or Register to view this content.
What was the selection at the beginning, it means how many cells did you select from column X when you start to drag over the columns
Else if 2 cells where covered (columns X and Y) then try
Please Login or Register to view this content.
Last edited by PCI; 12-17-2013 at 05:29 PM. Reason: additional info added
Below will do the same..
and for your query..Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Debraj Roy; 12-17-2013 at 06:00 PM.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
after i read your comment/question, I realized what was the problem. I didn't have the cell selected.
new code sample...
thank you for the helpPlease Login or Register to view this content.
this works even better. thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks