Search results

To Post codes use the codes as before code ([)code(]) after code ([)/code(]) Don't use this () Hope it clear

@ManuGrim can you please elaborate the problem what do you want to express exactly

@ManuGrim Please Change Your Code to This Sub Worksheet_change(ByVal Target As Range) If Target.Address = "$C$1" Then Select Case Target.Value Case Is = "House" Sheet1.Range("D:ZZ").EntireColumn.Hidden = True Sheet1.Range("D:F").EntireColumn.Hidden = False Case Is = "Car"...

Glad It Worked

@leimst Try the below code Sub Evaluate_Data() Dim i, j, LastRowSh1, LastRowSh2 LastRowSh2 = Sheets("Reference").Range("A" & Rows.Count).End(xlUp).Row LastRowSh1 = Sheets("Data").Range("A" & Rows.Count).End(xlUp).Row For i = 1 To LastRowSh2 For j = 1 To LastRowSh1 If...

No Luke I can't remember the links because they are too old and i try to remember they are but i can't now. it's ok no problem when i remember then sure i will knock your door bell One more thing, for what i am searching is i have created some excel files and i want these files are run only...

noop nothing is happen

Hi Luke Thanks for your Replay, sorry i can't remember that and i tried to search with few wards but i can't, and one more thing in my book mark there is one thread which is hui replied for restrict the file to work in another system with IP address or what any help about this Thanks

Hi I have Small Doubt that is how to find our Book Marks and Important Subjects which was settled in our Old Forum. Due to i have some important books are in there but i can't find them here and in my profile too Kindly Suggest me about this Thanks SP

@Sathish it's give the hole value as 9.11E+14 so there is little change Select Whole Column - > Ald +D+E - > Next - > Next - > Select Text - > Finish

@kumar Try this in B1 and copy down =IF(ISTEXT(A1),A1,IF(ISNUMBER(A1),TEXT(A1,"0")))

@Some it's give the same result of edited cell not difference

@kumar Select your range and Format them as number and remove the decimal placess in number format

@Abhijeet Why not you hide the Folder and sub folders from option of Folder and Search Option 1. First select the folder which you want to Hide 2. Right click on the Selected Folder 3. Select Properties 4. In the General Option you can find the Hide and Read only Access Now your...

@Pinang I am not sure It is possible and how much secure about our work As a blind sot just i tried a code please check Sub Formula_Hide() With Range("A1") .Formula="=Sum(1+1)" .Value =.Value End With End Sub Thanks

Bro do you need any more details about mine problem

Glad your problem solve

@Don Preston Sorry i can't understand, but what i understand i get the all borders and symbols in print preview what you have entered in Please Check the Attached Thanks

Hi Shrivallabha Congratulation on your 1st Mile stone keep watch guide us

@Sinu Please upload a sample file with your desire request i will try to solve your problem other wise our Ninja's too Thanks

@Dede Please start a new conservation Thanks

@Sinu Welcome to Chandoo.org, Glad You Are Here Please check this link http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ and http://www.contextures.com/xlDataVal14.html Hope It solves your problem, if any problem please come back Thanks

HI Deepak can you do the same thing for me to search the dealer from This link https://odishatax.gov.in/portal/Shared/DealerSearch.aspx

It is a Rajasthan Commercial Tax Department Site and here it must need to login http://www.rajtax.gov.in:7777/vatweb/ after that we can do any thing

@Asheesh Welcome to Chandoo.org Forum, Glad You Are here please refer the Below links may be it will give some idea http://www.pcreview.co.uk/forums/powerpoint-chart-preview-vba-userform-t3463215.html and http://www.vbaexpress.com/kb/getarticle.php?kb_id=756 Thanks