Search results

@DashboardNovice Place This Code in the Command Button and press Private Sub CommandButton1_Click() Sheet1.PrintPreview True For i = 1 To Worksheets.Count strRes = MsgBox("Do you want to print " & Worksheets.Item(i).Name, vbOKCancel, "Print Preview") If strRes = 1 Then...

@Richard Welcome to Chandoo.org, glad you are here Some of your requirement is done by formula and some to be use with VBA for export the PDF. It is better to upload a sample file with your desire required to understand before you start a point please check this link...

Hi SirJB7 After Long time we can C you, Glad you are back. and finally i got the thread which i start this thread http://chandoo.org/forum/threads/run-excel-file-only-on-designated-computer.9508/ actually in our profile page we can't get all the threads which we started or replied

@DMA Try The Below Code Sub UpdateLogWorksheet() 'http://www.contextures.com/xlForm02.html 'code by Dave Peterson and modified by cdbauer1 'Make sure that your column headers on the PartsData tab go in the order of the Data Validation list and that they are identically named Dim historyWks...

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