Reputation
236
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 5
Impact
~52k people reached

  • 0 posts edited
  • 0 helpful flags
  • 30 votes cast
Jul
28
answered USB drive shows 'RAW': can't format and can't delete volume
Oct
16
comment Efficient approach of selecting large amount of rows in an Excel file
I thought asking 'why not MS Access, at least?' but it could be misinterpreted...
Oct
16
comment Efficient approach of selecting large amount of rows in an Excel file
Or maybe (holding Shift) Control down, control left?
May
25
awarded  Autobiographer
Feb
22
awarded  Yearling
Oct
26
awarded  Commentator
Oct
26
comment Excel elapsed time format
+1 for the extensive and clear explanation :)
Aug
2
comment How to get excel row numbers to skip the header
@Gullu, I'm not sure about your 99% percent of headers in row 1... I'd say that I've seen many spreadsheets with headers coming into rows 2 or 3, keeping row 1 as padding. Again, there's no rule about row 1 contain in 99% of cases a header. Please, feel free to prove us we're wrong.
Aug
1
comment How to get excel row numbers to skip the header
This functionality is unlikely to have in Excel, IMO. It could only eventually create problems for less experienced users without adding a great payback value.
Aug
1
comment How do increase row height in excel by X. ie. Add verticle cell padding
So, your idea was to do it without using VBA? If so, you should've been clearer in your question... Anyways, I don't believe it's possible.
Aug
1
comment How do increase row height in excel by X. ie. Add verticle cell padding
IMO... SU: Excel-only tricks and functions. SO: Excel/VBA related tricks and functions.
Aug
1
answered How do increase row height in excel by X. ie. Add verticle cell padding
Aug
1
comment How do increase row height in excel by X. ie. Add verticle cell padding
I'd guess you'll eventually have at least some VBA here. Therefore... I'd move this question to SO instead of keeping it here in SU.
Jul
30
comment Excel VBA Function runtime error 1004: Application-defined or object-defined error
NW. I believe that @music2myear goal was to test his skills rather than do a specific development... so I'd guess he has a 'default' code his tweaking over an over again (but without updating some pieces that could help us out, like the message box).
Jul
30
comment Excel VBA Function runtime error 1004: Application-defined or object-defined error
Take a look at what the message box says... MsgBox ("There are " & intItemCount & " rows of data in column A."). AFAIK, COUNTA does exactly this. Take a look @ my comment to @PerryJ post.
Jul
30
comment Excel VBA Function runtime error 1004: Application-defined or object-defined error
Yeap... it seems that the topic says one thing, the function names another... and the code itself yet another thing.
Jul
30
answered Excel VBA Function runtime error 1004: Application-defined or object-defined error
Jul
22
comment In Microsoft Excel, how do you determine middle and end characters in these values?
Happy to know, thanks!
Jul
22
answered In Microsoft Excel, how do you determine middle and end characters in these values?
Jun
28
answered How to convert 24/12/2010 7:24:56 AM into a time in Excel 2007?