Previous Topic Next Topic

Macro - Predefine column ID

Closed
samkhu Posts 2 Registration date Wednesday October 17, 2012 Status Member Last seen October 31, 2012 - Oct 17, 2012 at 09:05 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 17, 2012 at 05:55 PM
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?

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 17, 2012 at 05:55 PM
where you want to pre define?

You would do same way as you are doing for row
0

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses