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