Search results

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...

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...

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

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...

@ 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

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...

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

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...

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...

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...

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...

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

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

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

@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...

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...

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

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...

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...

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...

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) +...

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 =...

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...

@ 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...

@ 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...