Search results

hEY i HAVE DONE IT i = 1 AND ActiveSheet.Cells(I, 40).Value = A cHEEERSS BUDDDYYYY.. rEGARDS iSTI

Hi sirJB. Need Your Help. I have some specifications. Sheet name = UPLD Name Range = Upld_str_avbl_list range =UPLD!$AN$2:$AN$65536 Now i want that output in Created name range. so now how to rectify code. Regards Istiyak

Heyyyy Cheeerrrrsss I Got What i want.... Thanks To You SirJB7.. Finallyy you have done it. always solving my problems.. Thanks again thanks a lot Regards Istiyak

HI, I have cross checked the Folder. it is there. I also have already added "Option Explicit" just not pasted in comment. It is not showing anything. Looking forward for the solution of the same. Regards Istiyak

Hi, Still Facing Issue. Now i m not getting any but output is not coming. Sub X() ' constants Dim desktoploc As String desktoploc = CreateObject("WScript.Shell").SpecialFolders("Desktop") & "Exported Data" Const ksFolder = "desktoploc" Const ksExtensions = "*.*" ' declarations Dim I...

Hi SirJB7 Sorry i havn't explain issue properly.. When i m execute that code. VBA editor stops the code at line Const ksFolder = CreateObject("WScript.Shell").SpecialFolders("Desktop") & "Exported Data" and there is no value is coming in Column A. Hope i will be understood. Regards...

Hi SirJB7.. Thanks for your response I have modified the code as below still facing issue. Sub X() ' constants Const ksFolder = CreateObject("WScript.Shell").SpecialFolders("Desktop") & "Exported Data" Const ksExtensions = "*.*" ' declarations Dim I As Integer, A As String ' start...

Is this possible to creat dropdown list based upon files available in Specific folder. I.e. folder on desktop = Exported data Files in folders = 0229.xls, 0429.xls, 02452.xls etc,. So is this possible to creat dropdown in my actual sheet. waiting for solution. Regards Istiyak

Hey Congo !!!! Congratulations Sir ..... :) Regards Istiyak

thnks Faseeh

hi SirJB7 Ya fair enough you are right your formula is working there. thanks for the same. Regards Istiyak

Hi, I don't know it right or wrong but i just wanted to know what is the Diffrerence Beetween "Class Module" and "Module" in VBA screen. Regards Istiyak

Why you need such software, U can save as the file as text or delimited file. U can also use vba as well. Any query plz let me know. Regards Istiyak

Hi SirJB7, 1.234,56 it means One and .234 part of other one. that's why excel converts 1.234,56 as 1.23456. Regards Istiyak

Hi NarayanK , what i can say,...??? Excel Ninja.... tussi great ho,. Thanks a million. Can I know why we are using CDbl..? Regards !$T!

Hey LukeM, Amazing, always learn something new from u dear,... Regards !$T!

Hi Luke, Naryank, And SirJB,, Sorry for the incomplete Details. Original Data is just for your reference so every time u can copy that data in A:D and do an experiment of Mecro.Its not attached at any point with Mecro. # SirJB7 I want Result 3447.00 as a number which is available as...

HI,, Hope this will helpful for u...

Ninjaa''''' Great... Regards !$T!

HI Hui Do you have any Soft copy (E-BOok) for the same..> If yes then plz upload it and share with us. I m also very mch exiting to learn the same. Regards Istiyak

Hi Team, I have uploaded one file on my website. http://www.istiyakshaikh.hpage.com > download > problem.xls Eximine the file and let me know what is the problem. Copy original data and paste it in column A to D (etc) While i m running a mecro it is convering value wrongly...

Hi Kalpesh, Do one thing get a help of helper column if don't want to remove duplicates. Do advanced filter and copy paste that in your helper column after that you can creat drop down list. Any query get back to us. Regards Istiyak

hi Vijay ,, Its Working Dear Cheers to u dear... Thanks. !$T!

HI Luke M Thanks for your solution thats work great..... reallyyy you are Excel Ninja..? Point #2 i already had tried that bt it is not working on another pc (Its working on My pcs where i my adding that control.) Thanks !$T!

Hi,,,.. i m having atleast 40-50 name ranges in my workbook. it is very long process to copy and paste name ranges in sheet for reference. Can i know is these possible to Extract Name Ranges To Excel Sheet.?? Regards !$T!