226 reputation
15
bio website lessonsit.com
location Valencia, Spain
age 30
visits member for 3 years, 6 months
seen Jul 28 at 19:21

A passionate team leader who loves his work and is always available to discuss the best approach to do things. As a leader, I seek for having not only the code done but the end user needs solved (which sometimes means no coding!).

I'm a little freaky about organization; I have (I believe) an above-the-average tendency to make sure not only coding is done but also documentation is updated and the 'non-code' is also done properly (requirements met, etc.).

After some years, I realized that coding is only a very small part of IT job: if coding is most of the work, then the work is being done wrongly! Besides, since 2011 I'm using Toggl to track my working hours to have a better view of where my working efforts are going. If by the end of the day you have that feeling of having accomplished nothing, I strongly suggest to use something like this. It worth a shot!

I'm also interested in volunteer activities (especially digital inclusion), so if you need a hand from a Portuguese / Spanish / English speaker, feel free to drop me a message!

If you want to know more about me, check me out @ LinkedIn or through my personal blog where I share the Lessons I learned (most of them, the hard way!).


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?