"rabc0011" = "abc0011" ????

  • Thread starter Thread starter hyyfte
  • Start date Start date
H

hyyfte

There must be a way to do this... I have a huge table with column A -
file names in a "RABC0011" format on one list and an "ABC0011" on
another list. I am trying to copy certain columns of the R table to
the other table. In order to do this I have to set up a loop to check
if filename equals RABC0011 minus the R, add column F, G and H. Is
there a way to make "Rxxxnnn" = "xxxnnn"?
 
sStr = "Rxxxnnn"
sStr1 = "xxxnnn"
if lcase(right(sStr,len(sStr1))) = lcase(sStr1) then

or

if Instr(1,sStr,sStr1,vbTextCompare) = 2 then
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
function which includes its own list - no table 2
get cell value where offset cell = X, use this value to populate list 8
VBA - retrieve data on last create named range from previous inserted named range 0
Problem sorting a range of columns using VBA 1
Pivot date, that's all 6
Loop Macro to add Formula only on rows with data 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7

Back
Top