Questions tagged as 'excel-2010'

1
answer

Run time error 13 Type mismatch

I have a problem with a macro that I am trying to make. You should look for a range of values that I give you in all the excel sheets and you should return the name of the sheets in which each value of the range appears. the error occurs when co...
asked by 02.01.2018 / 11:27
1
answer

Run a macro from a .bat

I wanted to know if it is possible to run a macro in Excel from a .bat file since I can not find a way to do it. The macro that I own works correctly but I need it to run when I run the .bat I would appreciate it if you know something,...
asked by 18.12.2018 / 17:43
1
answer

Bring data that depends on two columns

I have the following information: _____A___ _|______B_______|_______C_____ 1 | CODIGO | CONCEPTO | VALOR 2 | 111222 | con1 | 12000 3 | 111222 | con2 | 11000 4 | 111222 | con3 | 5000 5...
asked by 26.04.2018 / 01:14
0
answers

Help making a macro that passes whole columns according to its heading

Hi, I have a problem with a macro that I try to perform, before I had it with the macro recorder but then the tables started to grow and the headers change places every week, so now I want to select an entire column according to the headline tit...
asked by 15.11.2018 / 00:04
0
answers

How to activate the paragraph marks in Excel 2013 to visualize the end of the CRLF line in a * .csv file?

I need to activate the paragraph marks in Excel 2013, in word I already identify how to do it, adding this functionality to the ribbon. But in Excel I did not show the option Display (Display) to be able to activate the visualization. Could some...
asked by 04.10.2017 / 23:26