Search:
Type: Posts; User: seenu_1st
Search:
Search took 0.06 seconds.
-
yes, you are right, need to use only 1st digit for sorting. The cells may contain individual numbers and comma separated numbers too.
I have solved this by looping thru rows to extract 1st chr...
-
yes, you are right, need to use only 1st digit for sorting. The cells may contain individual numbers and comma separated numbers too.
Thanks!
-
normal sorting through VBA
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("A1:A7")
.Header = xlNo
.MatchCase = False
.Orientation =...
-
Hi Vbfbryce, thanks for your reply, 79 comes first, but i need 7,8,9 to be first.
-
Hello experts!
I have some data that a column contains number alone and comma separated together, I need to sort considering both criteria, example as shown below
Col A
3
5
7,8,9
11
6
-
good work ! thanks for ur time,
actually i m trying to do it by any formula / array formula with out any VBA code.
-
yes I agree, it is not only that column, i have other data in other columns, i m trying to highlight when enter a date (with lesser interval) in the column.
-
exactly ! camparing with each and every dates.
-
please see the image below, row 1 and 5 less than 4 days, row 3 and 5 less than 4 days, hope you get me now.
145673
-
not only between 2 dates, i need to check all the dates (between each date in the column) in the column A to be compared and should be more than 3 days.
Thank you,
-
hi,
thanks for your valuable time.
I have 'n' number of dates in column A, the interval between any date should be more than 3 days else need to highlight.
thanks in advance.
-
dear experts,
I need a formula to check the dates in a range which differs less than 3 days among them, I m going to highlight that cells by conditional formatting.
Thanks in advance.
...
-
Hi experts,
I need help to upload a file and compare the size using Winscp, any samples and suggestions pls
Thank u
-
Hi experts,
I have uploaded files to FTP by executing a batchfile thru vba code, i just need to check the file size which i uploaded to confirm that the file loaded fully
any suggestions and any...
-
@opus, i m trying with second option as it is faster, thanks for ur reply
@Doogle, thanks for ur reply, i wil try ur code, how to open multiple splited files simulatneously?
-
Dear friends,
I need to get the min / max XYZ value from a txt file, the txt file got 1000's of lines like 10,000, 20,000 and more lines
so line by line looping is very slow, any better idea to...
-
Hi Ria,
which line gives error? can u attach the file u tried?
-
Ria, the post #30 dosent help?
-
with out seeing the code cant predict the problem, post the code and which line gives the error?
-
do u need to do these from excel VBA or VB6?
-
can u post delete / insert code?
-
-
ur requirement may not be clear as the users to be understood, better start a new thread with clear info, Goodluck!
-
-
i hav only 2003 version, can u pls atach 2003 version pls?
-
whenever u change any row value in sheet1 Col A, u need that changed row value to be pasted in sheet2 A1, am i right? if yes then why dont u use Worksheet_Change event?
-
-
something like this
"Select * From Tablename Where Column1 <> 0"
-
is IE9 suitable for windows xp service pack 3?
-
firefox and google chrome is working fine, IE8 only the problem.
-
i hav tried the old verion, but it gives this error, pls see the image, i hav already uninstaled the latest one,
thanks for ur help!
-
thanks for the reply, where can i get the older version of flash player?
-
try like this
Private Sub Command1_Click()
Const FromFolder = "D:\seenu\from\" 'change path
Const FilePattern = "*.log" 'change pattern
Dim File As String
File = Dir$(FromFolder &...
-
but the names r date/time is it?
-
u need to loop thru each file in the folder with above Max187Boucher's FileDateTime() function to get the recent date/time.
edited: if the filename is Date/Time then u can compare the filename...
-
yes, see the attached excel file for example.
-
see this link if anything useful for u
-
may be With Block missing
With sheetname
'code
End With
r u running this code from excel or access?
-
Dear experts,
I m facing a problem with adobe flash player 11, my exact problem is, when the shockwave flash object addon in enabled in IE8, i cudnt attach anything in yahoo mail, if i disable that...
-
why dont u avoid 0 values when u open recordset by query?
|
Click Here to Expand Forum to Full Width
|