• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. nagovind

    Assign a result of VBA calculation to clipboard to paste

    Hi Narayan, Thank you for your reply Issue is 1. Result of the same macro varies each time it runs 2. Normally i did in the manner you said 3. Each time it run i need to go that cell then copy the data then i need to paste the data in the required cells 4. destination cell/ cells varies...
  2. nagovind

    Assign a result of VBA calculation to clipboard to paste

    Dear All, A macro that results with a variable results for each time (its a string) After running that macro i need to copy that result in the required place manually Query is, how to copy the end result of a macro in to clipboard so that if i use Ctrl V after running a macro in to the...
  3. nagovind

    Print Issues in this Excel Workbook (NON continuous printing)

    Hi Narayan, Wowww! Now the file as attached by you is oK It is behaving normally Please advise how to rectify this errors? i have many workbook with this type having printing issue Please Regards Govind
  4. nagovind

    Print Issues in this Excel Workbook (NON continuous printing)

    Dear All, Please refer to the attached Excel Workbook https://dl.dropboxusercontent.com/u/101570276/Print%20Issues.xls Aim is to print all sheets in the workbook in PDF PRINTER so convert to pdf First i clicked the preview then selected Entire Workbook then printed Also tried to print by...
  5. nagovind

    Excel Bug?

    @ vijay.vizzu, Thank you very much VBA code in the below KB resolved my issue with a single click http://support.microsoft.com/kb/119826 @ bobhc Thank you very much Your way of handling the issue also resolved the issue without taking any measures
  6. nagovind

    Excel Bug?

    Dear All, Please refer to the Excel sheet https://dl.dropboxusercontent.com/u/101570276/Excel%20Bug.xls Please refer to the Video https://dl.dropboxusercontent.com/u/101570276/Excel%20bug.wmv I tried to create a new sheet by copying the existing sheet using Ctrl+Shift+Mouse click First copy...
  7. nagovind

    Paste data in selected sheets - Loop through selected sheets

    Hi Lohithsriram, Code PERFECTLY works Thanks a lot for your code Sincerely Govind
  8. nagovind

    Paste data in selected sheets - Loop through selected sheets

    Hi Lohithsriram Thank you for your reply My query is 1) Do you mean grouping the sheets and then run the macro? YES Please refer to the attached VIDEO in the below Link https://dl.dropboxusercontent.com/u/101570276/Video_Paste%20data%20issue.zip Issue is, if the data is pasted in the...
  9. nagovind

    Paste data in selected sheets - Loop through selected sheets

    Dear All, Below is the code that paste the data in the selected sheets from clipboard It is doing the job perfectly But this is not working if the copied data contains an object instead it is pasting only in fist selected sheet and not in all sheets Please refer to the attached Worksheet-1...
  10. nagovind

    Autofill cells that contain data validation

    Hi lohithsriram, Thank you for your reply I have downloaded the file from the below link http://www.contextures.com/xlDataVal11.html Tried to include in my sheet but the same is not doing the job Please help to resolve the issue. My file is "for autoFILL.xlsm" other is the downloaded file...
  11. nagovind

    Autofill cells that contain data validation

    Dear All, Is there is any possibility to have auto-fill data entry if the cell contains data validation or by any means The required LIST of data is in the range C1:C10 Individdual cells from A1 to A10 cell is with data validation with LIST referring to the req. data in the range C1:C10 If...
  12. nagovind

    Concatenate range of data into one cell

    Thank you for your reply "The thing is the Row or Column must be stand alone and not have other data adjacent to it" Agreed Closed. Thanks for the code
  13. nagovind

    Concatenate range of data into one cell

    Wow IT is working perfectly irrespective of the data is in row or columns But please advise how to make it ONLY row data to be concatenated or Only column data to be concatenated
  14. nagovind

    Concatenate range of data into one cell

    Thank you for your reply Your code works 1. But it adds a 'comma' even for first cell data 2. Please advise how to modify the code such that the data is in the subsequent ROWS instead of columns Sincerely Govind
  15. nagovind

    Concatenate range of data into one cell

    @kchiba Actually i need versatile program so that range has to be modified as required So i need a VBA code @ Marc L Sub chk() [B1].Value = Join(Application.Index([A1:A10].Value, 1), ":") End Sub I have used your code as above with the data in the cells A1 to A10 But there is no results in B1...
  16. nagovind

    Concatenate range of data into one cell

    Dear All, There are strings/ numbers (irrespective of data type) in cells say A1 = Apple B1 = 2435 C1 = Google E1 = MSoffice .. .. .. K1 = $240@04 The requirement is to concatenate all those data in to a cell say B1 separated by comma Cell B1 shall contain...
  17. nagovind

    Add dates by Skipping user defined week ends and Public Holidays

    Dear Hui, Thank you very much I got it Thanks for your help Sincerely Govind
  18. nagovind

    Add dates by Skipping user defined week ends and Public Holidays

    Dear All, This is regarding adding dates For ex. i have the date of 13.11.2013 in cell A1 I need to add 10 working days and get the result in B1 (26.11.2013) In between this 10 working days i have 2 days weekend (Thu and Frid) and one public Holiday on 17.11.2013 How to calculate this...
  19. nagovind

    Scroll Bar with user defined increment / data

    Dear All, There are 2 set of data One set is in range A1:A10 other set is in B1:B10 I need to have a scroll bar with the data as in A1:A10 for each corresponding scroll bar data the corresponding cells in B cells has to be displayed I have tried with Form controls scroll bar but the...
  20. nagovind

    Count the no. of items in data validation LIST [SOLVED]

    With google search, i have modified combined Luke M and Narayan code. Below Code Works well for BOTH type of data validation either it is inside the cell or it is referring to other cell it will count the List items Thanks for all. Sub ValidationCount4() Dim ItemCount As Long Dim...
  21. nagovind

    Count the no. of items in data validation LIST [SOLVED]

    Dear Narayan, Is there is any possibility to have a optional seek so that to combine the 2 different type of codes as below IF error of ItemCount = Range(Right(Range("H4").Validation.Formula1, Len(Range("H4").Validation.Formula1) - 1)).Cells.Count then ItemCount = UBound(FormHolder) +...
  22. nagovind

    Count the no. of items in data validation LIST [SOLVED]

    Dear Narayan, It is perfectly Working I wrongly added your lines initially then i modified THANKS TO Luke M THANKS TO NARAYAN THANKS TO Hui Sub ValidationCount() Dim ItemCount As Long Dim FormHolder FormHolder = Split(Range("H4").Validation.Formula1, ",") ItemCount =...
  23. nagovind

    Count the no. of items in data validation LIST [SOLVED]

    Dear Narayan, Thank you for your reply The code is not working while running the code it is showing Compiler error: Invalid use of property Cursor is highlighting .Count Please guide me @Hui I agree with you but what Narayan says is matching with my requirement. "Suppose the DV...
  24. nagovind

    Count the no. of items in data validation LIST [SOLVED]

    @ Luke M, I found the issue Actually the cell contains data validation is H4 Actual data is not entered in the validation directly instead it is referred to the group of cells =$M$9:$M$11 which in turn contains the data as SC1 SC2 SC3 Please advise how to resolve this The data is in...
  25. nagovind

    Count the no. of items in data validation LIST [SOLVED]

    @ Luke M, Thank you for your reply But after running the code it is showing the result as Number of items in validation:1 But it should be 5 Please advise Thank you ------- @ Hui, Thank you for your reply This is a existing template created by others, i need to work on that hence i...
Back
Top