Previous Topic Next Topic

Macro - Predefine column ID

Closed
samkhu Posts 2 Registration date Wednesday 17 October 2012 Status Member Last seen 31 October 2012 - 17 Oct 2012 à 09:05
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Oct 2012 à 17:55
Hi There,

in order to add more flexiblity, I want to predefine the column criteria/search column ID at frontend ie in excel sheet and use it at backend (macro) in the below code instead of "B" and "C"

filterCriteria = Thiswb.Sheets(1).Range("B" & CStr(LSearchRow)).Value & Thiswb.Sheets(1).Range("C" & CStr(LSearchRow)).Value

Any suggestion pls?
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Oct 2012 à 17:55
where you want to pre define?

You would do same way as you are doing for row

Similar discussions

VBA column
sunilherode -
Ambucias -

2 responses
How to create a macro to copy and paste
johncarr1973 -
ac3mark -

3 responses
Convert data with rows into columns
pooja.bs -
TrowaD -

2 responses
How do I extract specific data from a cell in excel?
mcat79 -
ac3mark -

5 responses
How to modify the macro code for new structure of table
jpppol -
TrowaD -

9 responses